Conditional DTS

Last Post 15 Jan 2007 02:32 PM by exchangeme. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

15 Jan 2007 02:32 PM
We have several DTS packages with the data sources located in remote locations. Id like my DTS' to first "ping" the remote device and it's available then proceed with the DTS Task.
If it's unavailable then the scheduled package stops and waits for the next schduled time to run again.
Currently, if the frame line drops and then the DTS scheduled time comes up, it just sits there saying "executing". I have to stop it and restart when I get to work.
Thanks for the help and any suggestions.


Acceptable Use Policy