Geek Answers Handbook

SSIS error Failed to decrypt secure XML node

I created an SSIS package that has ftp pull files from an ftp server and saves to my local drive, but I get this problem.

With the same error message, I received only a warning, but today the operation fails.

Message:

Run as user: cam \ Package.Runner. Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:00:00 AM Error: 2012-02-15 10: 00: 00.61 Code: 0xC0016016 Source: Description: Failed to decrypt secure XML node "DTS: Password" with error 0x8009000B "The key is not valid for use in the specified state " You do not have permission to access this information. This error occurs when a cryptographic error occurs. Make sure you have the correct key. End Error Error: 2012-02-15 10: 00: 00.62 Code: 0xC0016016 Source: Description: Failed to decrypt secure XML node "DTS: Property" with error 0x8009000B "Key is invalid for use in the specified state". You do not have permission to access this information. This error occurs when a cryptographic error occurs. Make sure you have the correct key. End Error Error: 2012-02-15 10: 00: 33.53 Code: 0xC0029183 Source: Main FTP balance file Get FTP task Description: The file represented by "/ Concerto / Virtus_Reports / Concarto Principal Balance Report * .pdf" does not exist. DTExec termination error: Package execution returns DTSER_FAILURE (1). Started: 10:00:00 Ended: 10:00:33 am Expired: 33.088 seconds. Package execution failed. Failed to complete step.

+8
source share
7 answers

You can fix this problem by setting the security level property.

Protection Level : DontSaveSensitive

With this property, the package will not be password protected, and another server can access and perform any task with other credentials.

+8
source

When importing a package to SQL Server, select "Protection Level": Either

1- Do not save confidential data.

or

2- Relying on server storage and roles for access control.

Screenshot of the properties of the SSIS project package:

enter image description here

+5
source

Before creating and deploying a package, make sure that you change the solution property as follows:

  Run64BitRuntime = False
0
source

I got the same error message for FTP connections. I think this was due to the fact that I open the package during the launch of BIDS under different credentials for those with whom I created it.

As an inept workaround, I deleted and re-created the FTP connection. After that, he worked well.

0
source

The bulk of the SSIS job error

"0xC0029183 Source: FTP master balance file Get FTP task Description: The file represented by" / Concerto / Virtus _Reports / Concerto Principal Balance Report * .pdf "does not exist. End of DTExec error: package Completed: DTSER_FAILURE (1). Started: 10 : 00: 00 Finished: 10:00:33 AM. Elapsed: 33.088 seconds. Package failed. "

It seems that you do not have a pdf file along the path that you configured in your SSIS package. Please check the path and PDF files for import. Best regards, Branislav

0
source

Try saving the package using the "EncryptSensitiveWithPassword" option.

Step-1: right-click on your FTP connection manager, go to its properties (the lowest one, not the "Edit" button), and enter the password.

Step 2. Save the package using EncryptSensitiveWithPassword.

Step 3. Now edit the ling command in the SQL job agent, as shown below. / FILE "C: \ Fullpath from SSIS pkg.dtsx" / password DECRYPT

0
source

In the case of an FTP connection, you can simply create one Script task before the FTP task and set a password for it, for example

ConnectionManager FTPConn;

FTPConn = Dts.Connections ["FTP Connection Manager"];

FTPConn.Properties ["ServerPassword"] SetValue (FTPConn, Dts.Variables ["FtpPwd"] value.) ;.

and in the case of OLE DB, you can simply add the password to the OLEDB Connection connection string.

0
source

More articles:


All Articles