View Single Post
  #1 (permalink)  
Old May 25th, 2004, 06:00 PM
niravp niravp is offline
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default Scheduled DTS package does not work

I have an ActiveX script that moves data from one table to another and writes a flat file from second table to a remote server. When I execute the DTS package manually it works fine. However, when I schedule this package to execute on a specific time of the day, the flat file creation part fails but the task runs successfully--data gets moved and appropriated flags put in place.

I wonder why the same package works flawlessly when executed manually but fails to work the same way when it is scheduled. Does anyone have a suggestion?

Nirav