开发者

Updating Deployed SSIS Package

开发者 https://www.devze.com 2023-04-09 04:30 出处:网络
I have a deployed SSIS package, with a sche开发者_开发知识库dule 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

I have a deployed SSIS package, with a sche开发者_开发知识库dule 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?


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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号