SSIS Package Upgrade
Hi, I have a SSIS Solution with 4 packages created in SSIS 2005. When I opened the solution in SSIS 2008, it went for SSIS Upgrade wizard. But the upgradation had failed. The error messages are shown as follows : 1. Error 0xc001405f:: Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information. 2. Error 0xc001f429:Package Upgrade: The loading of the package Package1.dtsx has failed 3. Error 0xc0016016:: 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. What is the correct step for upgradation from 2005 to 2008 ?
April 27th, 2011 2:59am

1) This error occurs when there is package security applied in the existing package. This error is specific to EncryptSensitivewithuserkey. Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 4:37am

So whats the solution for this ? Should we have to apply the correct password in Select Package section , inside the wizard ?
April 27th, 2011 4:44am

1) During the upgrade , there would not be any option to set the package password right? 2) One option would be to use the option "DontSaveSensitive" option for the Protection LEvel and upgrade the package. 3)Do not forget to reapply the security setting again after the upgrade.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 5:02am

There are several solutions: Open the 2005 package in 2008 while logged in as the user that originally created the packages. Open the 2005 package in 2005, change the ProtectionLevel to EncryptSensitiveWithPassword, and save the package. Open the 2005 package in 2008, supply the password, and save it. Open the 2005 package in 2008, accept and ignore the reported errors. Edit the package to add back the sensitive information (connection passwords), and save it. Talk to me now on
April 27th, 2011 5:13pm

Hi , Is your 2005 package is connected to config file.If yes, remove the connection to config file and save the package. If you open this package in SSIS 2008 it would get automatically upgraded or even you can upgrade it using Upgrade wizard. Hope this helps :) Regards, Vaibhav
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 3:35am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics