SSIS: Deploy Packages to different locations

Once the package is ready, we have the following 3 options to deploy SSIS Package.

1.Deploy SSIS Package to the SQL Server (msdb Database).
SSIS packages will be deployed into msdb system database.


2.Deploy SSIS Package to the Package Store.
SSIS packages will be deployed under package store (C:\Program Files\Microsoft SQL Server\110\DTS\Packages). SSIS is made aware of this location through the Folder tab in MsDtsSrvr.ini.xml configuration file and which is located in SSIS installation directory C:\Program Files\Microsoft SQL Server\110\DTS\Binn.


3.Deploy SSIS Package to the File System.
SSIS packages will be deployed to Normal file system. Normal File system can be either file or folder.


The difference between Package store and normal File system is that when Packages are deployed into any folder other than package store (C:\Program Files\Microsoft SQL Server\100\DTS\Packages).

File system accesses only the packages which are placed under File System Folder location from Configuration file.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.