dbTalk Databases Forums  

DTS Package executes manually, errors when scheduled

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Package executes manually, errors when scheduled in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Noeuphoria
 
Posts: n/a

Default DTS Package executes manually, errors when scheduled - 10-09-2006 , 07:29 PM






I have a very simple DTS package that takes the results of a query and
exports them to a .csv file (on the same computer that is running SQL
server). I can manually execute this package easily, and it works each time.
However, if I schedule it, it always fails on the 1st step (there is only 1
step - execute the package). This is the error:

The process could not be created for step 1 of job
0x963FC27F17F02448B3072D4B0B8AD5C8 (reason: The system cannot find the file
specified). The step failed.



Reply With Quote
  #2  
Old   
Ken
 
Posts: n/a

Default Re: DTS Package executes manually, errors when scheduled - 10-10-2006 , 08:41 PM







The DTS package is run locally on your machine when you run it manually
and not on the server. When the scheduled job executes it it is on the
server..


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.