Why do I get the following error when executing a package under a SQL Server Agent job: "Failed to decrypt protected XML node "ServerPassword" with error 0x8009000B..."?
We recommend that you use EncryptSensitiveWithPassword.
If you want to set up package encryption with either EncryptAllWithPassword or EncryptSensitiveWithPassword, be sure to include the package decryption parameter.
You will need to consult Microsoft documentation for a better understanding of
how to set the /DECRYPT option with password in the DTEXEC command line. Information about
the DTEXEC command line options is available here.
In the image below, you can see that in the SQL Server Agent job step, there
is a /DECRYPT option to specify the password you gave the package in Visual
Studio
If you choose to use the option DontSaveSensitive,
all sensitive information like passwords is completely removed from the
package. This option can only be used if you provide your passwords from an
external configuration file or a table.
You may find the following articles useful:
Securing Your SSIS Packages Using Package Protection Level
Access Control for Sensitive Data in Packages
Book a Presales Call
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
When executing an SSIS package from the command line, it works properly. However, when I run the same package from the SQL Job Agent, it fails.
Make sure your SQL Job Agent user account has the following permissions: COZYROC SSIS+ installation folder (READ and WRITE). Windows temp folder (READ and WRITE). The default location is here: C:\Windows\TEMP Permission to access COZYROC registry ...Error Message: Failed to retrieve active package
Action: When executing an SSIS package containing a COZYROC task and/or component, the following error is encountered. Error Message: Parallel Loop Task: Error: An error occurred with the following error message: "Failed to retrieve ...I get the error message "Please specify server password." even though I don't need a password to connect to the FTP server.
The problem probably has to do with your setting for Package Protection Level. Even though the error is different, please see this article for an explanation: Why do I get the following error when executing a package under a SQL Server Agent job: ...When I run an SSIS package under the SQL Job Agent with a proxy account, I get the error: Access Denied
Make sure your proxy account has permissions to access the following: 1. The SSIS+ installation folder 2. One of the following registry keys, depending on whether you're using the 32 bit or the 64 bit version: 32bit - ...Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified"
Action: When running an SSIS package under the SQL Job Agent, the following error is encountered. Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error ...