Skip to content

January 24, 2012

Add a remote server to your local SSIS instance

by Scott Newman

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="" xmlns:xsi="">
    <Folder xsi:type="SqlServerFolder">
    <Folder xsi:type="SqlServerFolder">
    <Folder xsi:type="FileSystemFolder">
      <Name>File System</Name>

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.


Read more from SSIS

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Note: HTML is allowed. Your email address will never be published.

Subscribe to comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: