Migrating a DTS package using SQL Server wizard created a SSIS package but it shows a Variable path as and throws following error when opened in BIDS.
Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".
asked Nov 14, 2011 at 01:53 AM in Default
Your DTS had a password in it, the error message is telling you that the SSIS package cannot access that password as it was encrypted.
Simple answer - type the password into the connection and save.
answered May 19, 2013 at 10:17 PM