I have a DTS package that calls TurboFTP and FTPs a file. The package runs properly if I run it from DTS. The package is owned by a domain account, SQLAdmin, which is a member of the Domain Administrators. The owner of the scheduled job is the same domain account, SQLAdmin. Both SQL Server and the Agent run under this account. The executable that it's being called is installed locally on the server under C:\Program Files\TurboFTP. I have tried pointing the DTS package to both the C:\Program Files\TurboFTP path and the UNC path, \\<servername>\c$\Program Files\TurboFTP. All of these combinations give me the same result, I can run the DTS package on the server with no problems, but the scheduled job won't run. Any ideas? I read MS' KB article, but it didn't shed any light on the problems I'm seeing

The following errors are generated when the Scheduled Job tries to run..

DTSRun: Loading..

DTSRun: Executing..

DTSRun OnStart: DTSStep_DTSCreateProcessTask_

DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147220330 (80040496

Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code -1073741819, which does not match the specified SuccessReturnCode of 0

Error source: Microsoft Data Transformation Services (DTS) Packag
Help file: sqldts80.hl
Help context: 490

Error Detail Records
Error: -2147220330 (80040496); Provider Error: 0 (0
Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code -1073741819, which does not match the specified SuccessReturnCode of 0
Error source: Microsoft Data Transformation Services (DTS) Packag
Help file: sqldts80.hl
Help context: 490

DTSRun OnFinish: DTSStep_DTSCreateProcessTask_
DTSRun: Package execution complete

Thanks for your help

sean

How do you login on the server from where you are running this DTS Package? I used to have a similar error with executing ZIP utility. The account that I used to logon and run DTS package from there, which called for the ZIP utility didn't have network permission to run such .exe progrms, but once our network administrator gave my account the permissions and added it on the server where SQL Server was installed, I was able to run WinZip.exe from within my DTS package. Your issue might not be the same, but I would check the network permission for the account that is used from where this scheduled package is ran.

Computers 101...I reboot the server and it resolved the problem. NO idea what was hung and not letting the schedule jobs run the DTS packages, but rebooting the server resolved the issue.

thank

sean