|
Hi, 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.". any thoughts?
(comments are locked)
|
|
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.
(comments are locked)
|
Your answer
