SSIS FTP Package Fails as a Job but Runs Manually

  • 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