CODEWITHSUNDEEP
sqlsql-server-2005ssis
Jessica
Jessica

Reputation: 239

Updating Deployed SSIS Package

I have a deployed SSIS package, with a schedule and everything. Now, I have made changes to this package. Do I have to re-deploy it, and setup the schedule for it again, or is there a way for an already deployed SSIS package to be updated with the latest build?

Upvotes: 3

Views: 8389

Answers (1)

billinkc
billinkc

Reputation: 61211

Yes, you need to redeploy the package(s) to whatever location the scheduler expects to find the package(s).

You do not, however, need to recreate the job, configurations or any of that jazz, simply perform an in-place replacement of the dtsx package. If you stored it to the file system, copy the new version over it. If you stored it in SQL Server, use the command-line to replace it (approximately dtutil /file PkgName.dtsx /destserver thatdatabase /copy SQL;PkgName) or use the ssismanifest to deploy packages or my current favourite, use PowerShell for SSIS deployment and maintenance

Upvotes: 7

Related Questions