question

pvsrinivasrao avatar image
pvsrinivasrao asked

DTS to SSIS migration throwing Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".

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?
sql-server-2008ssissql-server-2000dts
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Mister Magoo avatar image
Mister Magoo answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.