June 23, 2013 at 12:45 pm
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.
NULL
Started: 14:25:49
Error: 2013-06-23 14:25:49.97
Code: 0xC0016016
Source:
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
NULL
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply