June 11, 2014 at 9:35 am
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
July 23, 2014 at 1:26 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply