Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slboytoy
Starting Member
30 Posts |
 Posted - 2005-06-21 : 11:45:27
|
| I've been looking up this issue for awhile now and haven't gotten to far. HEre is what I am trying to do.I want to check for text files to see if they are there first (all of them), then if they are, run the different DTS's packages, if they aren't, retry X amount of times and if they still aren't there after X amount of times, run an activex script to send me an email.I'm having problems with the retry part. In ActiveX, there is DTSStepScriptResult_RetryLater. But I don't know how you can set an interval delay. I don't want to create a loop because I don't want the server to be tied up, I just want it to sleep every minute (For example). |
|
|
|
|
|
Retry DTS package