In a processing system I wanted SSIS to pause for a period of time (say 1 minute) to allow more data to arrive in my Import db.
The obvious solution was an empty 'For Loop' Container, constrained by looping until a minute had passed. Whilst trialing this approach I noticed the Physical Memory usage slowly increase (until it eventually consumed all memory and the package crashed).
My new approach is using an 'Execute SQL' task (shown below).
Basically, I am using the TSQL WAITFOR command, like this > WAITFOR DELAY '00:01:00'.
I am happy to report no memory issues and my package is running continuously with no unwanted side effects...
No comments:
Post a Comment