Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DTS package run while in the designer but not when scheduled.


DTS package run while in the designer but not when scheduled.

Author
Message
GF
GF
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 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.

Gary



alezar
alezar
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
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

Alex.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search