I am using a DTS package that copies files from another server and then runs some stored procedures. DTS runs on a scheduler.
However lately while coping files, I get err.number = 2147023570 with no description.
This error happens only when it is run from the scheduler. When I run manually, it seems to copy fine. What would be problem?
Appreciate your answer
Dhiresh