Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SSIS: Custom Folder in your Package Store

Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store.  I promised to provide the steps in my blog on how to do this.  So, here you go.

First, open the MsDtsSrvr.ini file, which is stored here by default:

C:\Program Files\Microsoft SQL Server\100\DTS\Binn

With the file open copy the following code chunk:

image

Change the Name attribute to the desired name and change the StorePath attribute to the location where your SSIS Packages will be stored.  Paste the the changed code directly below the snippet that you copied.  The file should resemble the following:

image

Save the file and restart your SQL Server Integration Server.  Once it is restarted connect to the integration server, then expand the Stored Packages folder.  You will see your new folder listed there.  Any packages that are stored in that folder will also be listed in the tree as shown below:

image

Talk to you soon,

Patrick LeBlanc, MVP, founder www.sqllunch.com

Sharing everything he learns about SQL Server…..

Comments

Posted by ThomasLL on 8 February 2011

Excellent post. Thanks Patrick

Thomas

TheSmilingDBA

Posted by David Pendleton-469334 on 12 February 2011

This tip is a bit more useful if you point the new folder at a file system location other "..\Packages"

As demonstrated, this is really just creating an alias for the "File System" folder and the same packages will appear in both folders.

You can actually use this method to manage any folder using the SSIS service and SSMS.

Leave a Comment

Please register or log in to leave a comment.