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?

asked Nov 14 '11 at 01:53 AM in Default

pvsrinivasrao
174 ● 23 ● 27 ● 27

(comments are locked)

1 answer:

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 at 10:17 PM

Mister Magoo
480 ● 3

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

sql-server-2008 x1611
ssis x758
sql-server-2000 x455
dts x62

asked: Nov 14 '11 at 01:53 AM

Seen: 1450 times

Last Updated: May 21 at 03:09 AM

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

Follow this question

Related Questions