http://www.sqlservercentral.com/blogs/sqldownsouth/2011/02/07/ssis_3A00_--custom-folder-in-your-package-store/

Printed 2014/09/01 02:53AM

SSIS: Custom Folder in your Package Store

By Patrick LeBlanc, 2011/02/07

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…..


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.