Package load attempt and getting failed

Question

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.

Answer 1

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.

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.