Add a remote server to your local SSIS instance

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.

SSIS

Log Backup Chain

If you break your log backup chain by switching a database into simple recovery or by executing BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY, there is a misconception that you then have to do a full backup in order to get your transaction log backups to run again.  This is incorrect.  Once you switch your recovery model back to full you only have to do a differential backup in order to restore the chain.

See Paul Randal’s blog post for more information (and an example script to demonstrate this).