ERROR:
Description: The package is encrypted with a password. The password was not specified, or is not correct. End Error Could not load package “\MSDB\SSISPaketi_adi” because of error 0xC0014037. Description: Failed to remove package protection with error 0xC0014037 “The package is encrypted with a password. The password was not specified, or is not correct.”. This occurs in the CPackage::LoadFromXML method
EXPLANATION:
You may receive such an error when you want to run an SSIS package with code like the following:
1 | dtexec /DTS "\MSDB\SSISPaketi_adi" /SERVER DWSQL /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V |
The reason you get this error is that the SSIS package is encrypted and you did not specify it in dtexec with the “/De
” parameter.
SOLUTION:
When running this SSIS package with “dtexec”, use the “/De
” parameter to run it as follows:
1 | dtexec /DTS "\MSDB\SSISPaketi_adi" /SERVER DWSQL /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V /De 1234 |
I see this error ant the package is not encrypted.
Is it corrupt?
Probably your password is not correct.