Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DTS package run while in the designer but not when scheduled. Expand / Collapse
Posted Wednesday, June 11, 2014 9:35 AM


Group: General Forum Members
Last Login: Wednesday, October 19, 2016 11:18 PM
Points: 468, Visits: 985
I have a DTS package that connects to the database and generates text files.
After each text file is created there is a process task that zips up the text file.

Here is the weird thing,
When I am in the DTS designer everything works just fine.

If I am logged in and run the package from a scheduled job all the zip files get created but the text files do not.
Winzip uses the file that was there before.

So basically the text files are not being generated but the winzip is zipping the files when the package is run from a schedule.
It makes no difference if I am logged in or not.

I have run the job as an administrator, and as sa but no difference in out come.

Any ideas would be appreciated.


Post #1579703
Posted Wednesday, July 23, 2014 1:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 14, 2015 3:34 AM
Points: 9, Visits: 73
Hi Gary,
this is very strange.

If the Zip process is connected to the text file creation process by an 'on success' workflow it's not possible that the file creation fails and the ZIP process is executed.

An incorrect setup of the Sql server agent could cause issues when the DTS interacts with the file system but it seems that this is not the case because you tested different users.

You should do the following :
in enterprise manager open the sql server agent and go to Jobs
look for your job, right click, view job history
check 'show step details' , copy and check the messages from the job steps

If you have still problems getting a solution you could post :
the above messages
the DTS saving it as a Structured Storage File

Post #1595364
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse