Package load attempt and getting failed

Jinal Contractor 121 Reputation points
2022-04-22T16:37:53.687+00:00

I've created SSIS package to create a data file and sending file to SFTP. SQL script > save data into .csv > send file to SFTP. However files get generated but file isn't able to transfer to SFTP site.

File gets transferred when I test manually but not in automated and getting failed with following error. I have password set on package property still getting failed.

Code: 0xC001405F Source: Package Description: Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information. End Error Error: 2022-04-22 11:11:33.07 Code: 0x00000000 Source: TF Secure FTP Task ExecuteTask Failed Description: ChilkatLog: UploadFileByName: DllDate: Jul 26 2021 ChilkatVersion: 9.5.0.88 UnlockPrefix: SNTRYN.CBX072023 Architecture: Little Endian; 64-bit Language: .NET 4.0 / x64 VerboseLogging: 0 SshVersion: SSH-2.0-Serv-U_15.3.0.1357 SftpVersion: 0 Component successfully unlocked using purchased unlock code. Must first have an open SFTP channel (by calling InitializeSftp). --UploadFileByName --ChilkatLog End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:10:23 AM Finished: 11:11:33 AM Elapsed: 69.718 seconds. The package execution failed. The step failed.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,381 Reputation points
    2022-04-25T02:47:06.473+00:00

    Hi @Jinal Contractor ,

    Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information.

    Please try to set the protection level of the pakcage.

    Set it to DontSaveSensitive for a try.

    195945-image.png

    ssis-issue-failed-to-decrypt-protected-xml-node
    access-control-for-sensitive-data-in-packages

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.