question

JinalContractor-2125 avatar image
0 Votes"
JinalContractor-2125 asked JinalContractor-2125 commented

Package load attempt and getting failed

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered JinalContractor-2125 commented

Hi @JinalContractor-2125,

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.



image.png (12.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Zoehui-MSFT I did save package to do not sensitive level but still getting failed with following error.

Microsoft (R) SQL Server Execute Package Utility Version 11.0.7507.2 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 9:50:40 AM Error: 2022-04-26 09:51:36.87 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: 9:50:40 AM Finished: 9:51:36 AM Elapsed: 56.766 seconds. The package execution failed. The step failed.

0 Votes 0 ·