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.