开发者

SSIS Continue a complex dataflow from step 12

开发者 https://www.devze.com 2023-03-18 16:17 出处:网络
I have a complex Task flow that in general creates data warehouse content from Prod to a local DW server and then a copy of that to an offsite location.

I have a complex Task flow that in general creates data warehouse content from Prod to a local DW server and then a copy of that to an offsite location.

Lately we keep failing in the copy to offsite. Sure we moved offices and are getting these lines operation as expected. Till then how do I get to run steps 12->20 and skip all of the first local steps?

开发者_运维知识库

TIA


It might make sense to to break steps out in seperate packages and invoke them in seperate steps perhaps in an agent job. In the immediate you can disable the steps 1-11 and then run the package

0

精彩评论

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