Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Agent not.... Expand / Collapse
Posted Tuesday, September 25, 2007 12:23 PM


Group: General Forum Members
Last Login: Friday, April 20, 2012 6:54 AM
Points: 12, Visits: 86
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\" "/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

Post #402698
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse