June 25, 2014 at 1:28 am
Hi
As part of an ETL process which takes several days I need to build in an auto pause on processing with no set time for restarting it again. So we cannot use the script
WAITFOR DELAY '00:01:00'
Apparently the Loop is not an option as it uses too much CPU.
We need to run a few manual checks and there is no way to determine the amount of time needed. After these check are done I need some way of resuming the package from where it stopped.
The obvious way probably is to build this into two separate packages but this would break the logical way our containers are being setup, in other words, it would make us break a container into two different parts in different packages.
Andre
June 25, 2014 at 2:54 am
SSIS is not build to be interactive.
This means there are only work arounds, such as looping and using WAITFOR in TSQL or even messageboxes in the designer.
It seems splitting it up in two seperate packages is the logical thing to do.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply