Adding a folder to the SSIS Package Store

V-rajbog
Posted by in Sql Server category on for Intermediate level | Points: 250 | Views : 5033 red flag
Rating: 5 out of 5  
 1 vote(s)

The SSIS Package Store is a nice option to available for storing SSIS packages. The Package Store list packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\Microsoft SQL Server\100\DTS\Packages for SQL 2008) in the File System folder.

It is possible to adjust the Package Store to look for packages in different file system folders or different server instances. To do this you must change the MsDtsSrvr.ini.xml file in the C:\Program Files\Microsoft SQL Server\100\DTS\Binn (folder is in SQL 2008 only).


 Download source code for Adding a folder to the SSIS Package Store

The SSIS Package Store is a nice option to available for storing SSIS packages.  The Package Store list packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\Microsoft SQL Server\100\DTS\Packages for SQL 2008) in the File System folder.  
  
Add a new File System folder to the Package Store. 

  1. Navigate to the file C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml and open it notepad or any program that can edit an xml file. 
  2. To add a second File System folder Package Store add the following highlighted code with the file path you want between <StorePath> and </StorePath> (Be careful when making these changes.  You may want to make a copy of the file before making changes): 
<?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>.</ServerName> 
    </Folder> 
    <Folder xsi:type="FileSystemFolder"> 
      <Name>File System</Name> 
      <StorePath>..\Packages</StorePath> 
    </Folder> 
    <Folder xsi:type="FileSystemFolder"> 
      <Name>My Packages</Name> 
      <StorePath>C:\SSIS</StorePath> 
    </Folder> 
  </TopLevelFolders> 
</DtsServiceConfiguration> 

3. If you want to change to a different server instance then type the new server instance between <ServerName> and </ServerName>. 

4. After you have made these changes and saved the file restart the SQL Server Integration Services in the SQL Server Configuration Manager. 

Your new folder will not appear until you restart the service.  You can connect to Integration Services in Management Studio and find your new folder.
 
Please find the attached file for the same
Page copy protected against web site content infringement by Copyscape

About the Author

V-rajbog
Full Name: Rajasekhar Boggarapu
Member Level:
Member Status: Member
Member Since: 3/17/2011 3:21:25 AM
Country: India
Rajasekhar Boggarapu
http://www.dotnetfunda.com

Login to vote for this post.

Comments or Responses

Posted by: Rameshannam on: 3/21/2011 | Points: 25
Very Good Content.

Login to post response

Comment using Facebook(Author doesn't get notification)