Pages

Men

rh

7/07/2012

How would you deploy a SSIS Package on production?


A) Through Manifest
1. Create deployment utility by setting its property as true .
2. It will be created in the bin folder of the solution as soon as package is build.
3. Copy all the files in the utility and use manifest file to deploy it on the Prod.
 
B) Using DtsExec.exe utility
 
C)Import Package directly in MSDB from SSMS by logging in Integration Services.

No comments :

Post a Comment