在IScatlog中禁用SSIS包 [英] Disabling SSIS packages in IScatlog
问题描述
大家好,
大家好日子。
我们有大师package(使用Execute包任务调用所有其他包) 部署到IScatlog中。我很想知道是否有办法禁用执行包任务(技术上禁用包的执行)而无需打开和重新部署
解决方案。
提前致谢。
Dileep Achhala。
ADKR
嗨 Dileep,
您可以使用DTExec运行包,并设置禁用执行包任务的属性为true。
像这样:
dtexec / isserver" \SSISDB \ MyFolder \ MyProject \ MyPackage.dtsx" / server"。" / SET" \Package\Execute Package Task.Properties [Disable]" ;; true
原始包执行:
禁用执行包任务:
相关链接: dtexec Utility
Hi All,
Great day everyone.
we have a master package(which calls all other packages with Execute package task) deployed into IScatlog. i am curious to know if is there a way to disable Execute package task(technically disabling execution of package) without opening and redeploying solution.
Thanks in advance.!
Dileep Achhala.
ADKR
Hi Dileep,
You can use DTExec to run the package, and set the Disable property of the Execute Package Task to true.
Like this:
dtexec /isserver "\SSISDB\MyFolder\MyProject\MyPackage.dtsx" /server "." /SET "\Package\Execute Package Task.Properties[Disable]";trueOriginal Package Execution:
Execute Package Task disabled:
Related link: dtexec Utility
这篇关于在IScatlog中禁用SSIS包的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!