SSIS XML Decryption Message

Question

My SSIS package says it is successful, but when it works, it does nothing (what I see).

The only thing that is wrong is the message (that it does not qualify as an error).

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

I have a password for my packages, but I don’t see anywhere to enter a password when loading a package in SSIS.

Am I missing a step?

Answer 1

This link discusses this problem and its solutions:

http://support.microsoft.com/kb/918760

Here is a summary from this page. See this page for more details.

, . . :

, SQL Server, . SSIS.

:

• . , , ProtectionLevel .
• SQL Server, , , .
• , , . , , . , , , SSIS.
• SSIS HKEY_CURRENT_USER. HKEY_CURRENT_USER .
• , .

Answer 2

pkg , , " ". Test Connection, SSIS .   . SQL Job Agent .