I am running sql server 2016 express. I created an import package with the import wizard and saved it to the file system. I gave it a password of P@ssw0rd to encrypt all data. I try to run it with the following command line: dtexec /f c:\work\ntd.dtsx /decrypt P@ssw0rd
but it fails with the following error:
Description: Failed to remove package protection with error 0x80131430 "(null)". This occurs in the CPackage::LoadFromXML method.
1. does sql server 2016 express support this?
2. can someone explain why this fails? Running it from the import wizard works fine.