SSIS authorized access this information error

0

Error is as following:

Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that

sql
ssis
sql-server-2008-r2
asked on Stack Overflow Aug 9, 2013 by Kumar • edited Aug 12, 2013 by makciook

1 Answer

0

Right click on empty space in your package and select properties. In the shown properties select package password as 'Dont save Sensitive' save the package and rebuild the entire project or solution and then save the package and close the ssis.

When you open again it asks for all the passwords.just provide all the passwords and it should work fine.

answered on Stack Overflow Aug 13, 2013 by Trini

User contributions licensed under CC BY-SA 3.0