Scheduled DTS Package Fails

[JohnEck]

I have a DTS package that FTPs a file then unizps and loads the data. When I execute it from the designer it works. When I try to schedule it it crashes. Here is the error
Executed as user: condor\sqlservice. ...art: DTSStep_DTSFTPTask_1 DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147024893 (80070003) Error string: The system cannot find the path specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147024893 (80070003); Provider Error: 0 (0) Error string: The system cannot find the path specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147024893 (80070003); Provider Error: 0 (0) Error string: The system cannot find the path specified. Error source: Micros... Process Exit Code 2. The step failed.

Any ideas?

 

[mrdenny]

Sounds like when you run it in designer you are getting the file from a mapped drive. When SQL Logs in no drives are mapped. Use the full UNC path.

Other problem might be:
When you designed the DTS package, you used your workstation. When you run the DTS package you do it on your workstation. When the SQL Server runs the DTS package it runs it on the server. The file structors aren't the same. Make sure that what ever folder you are using to FTP the folder to exists on both the server and your workstation.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[JohnEck]

Thanks, The post got me thinking it was crashing on the second step and not the first. This was the case. I needed to install software to unzip the file. It works now.

 

[mrdenny]

cool

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)