Normally when we create SSIS packages, in connection managers we may specify the password for some connections. It can be SQL authentication for an OLEDB connection, FTP connection or something else.
When we specify such passwords which are sensitive information, either we should create a config file which stores these passwords or we have to save the package as "EncryptSensitiveWithPassword" and speficy the password for the package.
Whenever we specify a password for the package, and later when we want to execute that ETL using SQL job, we have to specify the password details even in the job.
Else, we may end up getting the below error:
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.
To avoide this error, in SQL job, under "Command Line" properties, choose the option "edit the command line manually" and then type password just after "/DECRYPT".
Command line may look as below:
/FILE "D:\TestETL.dtsx" /DECRYPT pwd123 /CHECKPOINTING OFF /REPORTING E
Here pwd123 is the password for the ETL TestETL.dtsx
When we specify such passwords which are sensitive information, either we should create a config file which stores these passwords or we have to save the package as "EncryptSensitiveWithPassword" and speficy the password for the package.
Whenever we specify a password for the package, and later when we want to execute that ETL using SQL job, we have to specify the password details even in the job.
Else, we may end up getting the below error:
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.
To avoide this error, in SQL job, under "Command Line" properties, choose the option "edit the command line manually" and then type password just after "/DECRYPT".
Command line may look as below:
/FILE "D:\TestETL.dtsx" /DECRYPT pwd123 /CHECKPOINTING OFF /REPORTING E
Here pwd123 is the password for the ETL TestETL.dtsx
No comments:
Post a Comment