September 25, 2007 at 12:23 pm
Hi,
I have a job that runs a ssis package but the job will not execute the second step which uses a 3rd party software to download a file from a sftp server. My logon is in the admin group, I am using Local System as the logon service for sqlserver agent, my account has sysadmin server role in sqlserver, I added my account to logon as a service and batch job in local services, my account created the package. The package will execute fine using dtexec and windows task scheduler. I've even tried scheduling the job with a proxy and that won't work either. i'm running xp prof. Any other ideas? Here is the error:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 9:13:14 AM
Error: 2007-09-25 09:13:17.62
Code: 0xC0029151
Source: Execute Process Task Execute Process Task
Description: In Executing "C:\Documents and Settings\mroush\Desktop\SQL 2005 DMS project-Prod\WinSCP3\WinSCP3.com" "/script="C:\Documents and Settings\mroush\Desktop\SQL 2005 DMS project-Prod\Download E-Apps\sftpscript.txt"" at "", The process exit code was "1" while the expected was "0".
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 9:13:14 AM
Finished: 9:13:17 AM
Elapsed: 2.875 seconds
thanks,
mike
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply