In order to add a remote server to your local instance of ssis you have to add said instance to your config file for ssis. The location of your config file for ssis is C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.ini.xml (if on x64).
<?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>.\DENALI</ServerName> </Folder> <Folder xsi:type="SqlServerFolder"> <Name>WhateverServerYouWantToConnectTo</Name> <ServerName>ServerName\InstanceName</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>
After you’ve added the server, you’ll need to restart the Integration Services service on your local machine. Then, open up the integration services on your local machine, expand the Stored Packages node and you should see the machine that you just added.