Thursday, June 2, 2011

SSIS Package Re deployment

Deploying around 100 packages in SQL server mode will take long time. If we have any changes in few packages, forces complete deployment by the deployment manifest file. This can be avoided by editing the manifest file.

Link is having sample deployment manifest file to deploy needed packages alone. This will also update the configuration details used in separate file.We need to add the package name need to be deployed like
ETL_SALES.dtsx
ETL_SALES_NEW.dtsx


Sample File

No comments:

Post a Comment