View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
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).
It’s a pretty simple change that you can even use notepad to do. Here are the steps to follow to 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 and (Be careful when making these changes. You may want to make a copy of the file before making changes):
true MSDB . File System ..\Packages My Packages C:\SSIS
3. If you want to change to a different server instance then type the new server instance between and .
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.
Other posts by DevinKnight