更新部署的 SSIS 包 [英] Updating Deployed SSIS Package

问题描述

我有一个已部署的 SSIS 包，带有时间表和所有内容.现在，我对该包进行了更改.我是否必须重新部署它，并再次为其设置时间表，或者是否有办法使用最新版本更新已部署的 SSIS 包?

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?

推荐答案

是的，您需要将包重新部署到调度程序希望找到包的任何位置.

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

然而，您不需要重新创建作业、配置或任何爵士乐，只需执行 dtsx 包的就地替换即可.如果您将其存储到文件系统，请将新版本复制到它上面.如果存储在 SQL Server 中，请使用命令行替换它(大约为 dtutil/file PkgName.dtsx/destserver thatdatabase/copy SQL;PkgName)或使用 ssismanifest 部署包或我当前最喜欢的，使用 PowerShell 用于 SSIS 部署和维护

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

这篇关于更新部署的 SSIS 包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！