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

SSIS FTP Package Fails as a Job but Runs Manually Expand / Collapse
Posted Sunday, June 23, 2013 12:45 PM



Group: General Forum Members
Last Login: Friday, November 18, 2016 12:42 PM
Points: 2,947, Visits: 9,054
I wrote an SSIS package that pulld files from a client's FTP site. When run manually through "Execute Package Utility" -> "Execute" it runs to completion.

If I try and run it in a query window
exec xp_cmdshell 'dtexec /DTS "\MSDB\Website_FTP_Import" /SERVER MySQLServer Name /CHECKPOINTING OFF  /REPORTING V '

, I get the following error, saying the password is not allowed. But the password is in the package and it works when run the other way.:

Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2520.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 14:25:49
Error: 2013-06-23 14:25:49.97
Code: 0xC0016016
Description: Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that
the correct key is available.
End Error
Error: 2013-06-23 14:25:54.08
Code: 0xC001602A
Source: Website_FTP_Import Connection manager "FTP Connection Manager"
Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed
End Error
Error: 2013-06-23 14:25:54.08
Code: 0xC002918F
Source: FTP Task - RoundTable FTP Task
Description: Unable to connect to FTP server using "FTP Connection Manager".
End Error
Warning: 2013-06-23 14:25:54.08
Code: 0x80019002
Source: Website_FTP_Import
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specifie
d in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 14:25:49
Finished: 14:25:54
Elapsed: 4.203 seconds

Post #1466542
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse