Full Time DBA - SSIS http://www.fulltimedba.com/ SQL tips for database administrator en-us Full Time DBA Sat, 13 Dec 2008 01:17:25 GMT newtelligence dasBlog 2.2.8279.16125 fulltimedba@gmail.com fulltimedba@gmail.com http://www.fulltimedba.com/Trackback.aspx?guid=b7a50119-3555-4375-bd48-70089ef5b1a2 http://www.fulltimedba.com/pingback.aspx http://www.fulltimedba.com/PermaLink,guid,b7a50119-3555-4375-bd48-70089ef5b1a2.aspx Full Time DBA http://www.fulltimedba.com/CommentView,guid,b7a50119-3555-4375-bd48-70089ef5b1a2.aspx http://www.fulltimedba.com/SyndicationService.asmx/GetEntryCommentsRss?guid=b7a50119-3555-4375-bd48-70089ef5b1a2

If you are using SQL authentication for the database connections in your SSIS package you may get the following error message when you schedule your SSIS package.

   Code: 0xC0016016

   Source:

   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 the correct key is available.

You can do the followings to fix the problem:

1.     1.       Change the Package Security ProtectionLevel from EncryptSensitiveWithUserKey to DontSaveSensitive

2.       2.      Enable package configurations by right click on the package design surface and click "Package Configurations.."  to start Package Configuration Organizer.

3.       Create configuration file using the Package Configuration Organizer.

4.       4.     Modify the configuration file and store the password information of your connection string in the configuration file

5.           5.      Run your package using the configuration file.

 

 


Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state http://www.fulltimedba.com/PermaLink,guid,b7a50119-3555-4375-bd48-70089ef5b1a2.aspx http://www.fulltimedba.com/2008/12/13/FailedToDecryptProtectedXMLNodeDTSPropertyWithError0x8009000BKeyNotValidForUseInSpecifiedState.aspx Sat, 13 Dec 2008 01:17:25 GMT <div class=gmail_quote> <p class=MsoNormal style="MARGIN: 0in 0in 10pt"> <font face=Calibri size=3>If you are using SQL authentication for the database connections in your SSIS package you may get the following error message when you schedule your SSIS package. </font> </p> <p class=MsoNormal style="MARGIN: 0in 0in 10pt"> <font size=3><font face=Calibri><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Code: 0xC0016016</font></font> </p> <p class=MsoNormal style="MARGIN: 0in 0in 10pt"> <font size=3><font face=Calibri><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Source:</font></font> </p> <p class=MsoNormal style="MARGIN: 0in 0in 10pt"> <font size=3><font face=Calibri><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>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 the correct key is available.</font></font> </p> <p class=MsoNormal style="MARGIN: 0in 0in 10pt"> <font face=Calibri size=3>You can do the followings to fix the problem:</font> </p> <div lang=EN-US vlink="purple" link="blue"> <div> <p style="TEXT-INDENT: -0.25in"> <span>1.<span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span><font face=Verdana size=2>1.</font><span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;</span></span>Change the Package Security ProtectionLevel from EncryptSensitiveWithUserKey to DontSaveSensitive </p> <p style="MARGIN-LEFT: 0.5in"> <img src="http://www.fulltimedba.com/content/binary/SSIS_security.jpg" border=0> </p> <p style="TEXT-INDENT: -0.25in"> <span>2.<span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span><font face=Verdana size=2>2.</font><span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>Enable package configurations by right click on the package design surface and click "Package Configurations.."&nbsp; to start Package Configuration Organizer. </p> <p style="MARGIN-LEFT: 0.5in"> <img src="http://www.fulltimedba.com/content/binary/SSIS_PConfiguration1.jpg" border=0> </p> <p> <span>3.<span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span>Create configuration file using the Package Configuration Organizer. </p> <p style="MARGIN-LEFT: 0.5in"> <img src="http://www.fulltimedba.com/content/binary/SSIS_PConfiguration2.jpg" border=0> </p> <p style="TEXT-INDENT: -0.25in"> <span>4.<span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span><font face=Verdana size=2>4.</font><span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>Modify the configuration file and store the password information of your connection string in the configuration file </p> <p style="MARGIN-LEFT: 0.5in"> <img src="http://www.fulltimedba.com/content/binary/SSIS_PConfiguration3.jpg" border=0> </p> <p style="TEXT-INDENT: -0.25in"> <span>5.<span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span><font face=Verdana size=2>5.</font><span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;</span></span><span><span style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;</span></span></span></span>Run your package using the configuration file. </p> <p> &nbsp; </p> <p> &nbsp; </p> </div> </div> </div> <br> <img width="0" height="0" src="http://www.fulltimedba.com/aggbug.ashx?id=b7a50119-3555-4375-bd48-70089ef5b1a2" /> http://www.fulltimedba.com/CommentView,guid,b7a50119-3555-4375-bd48-70089ef5b1a2.aspx SSIS