Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, June 11, 2014 9:35 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 442, Visits: 801
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.

Gary



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, July 30, 2014 5:58 AM
Points: 9, Visits: 61
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

Alex.
Post #1595364
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse