Error in upgrading SSIS project to 2012 RC0

Asked By jibika 0 points N/A Posted on - 02/13/2012

I have a SQL Server Integration Services project which I needed to convert to SSIS 2012 RC0 and always failed with the error posted below. This project is configured with FTP Task and one of it is the FTP Server Port. It is set to 36360.

How can I get rid of the error?

Microsoft Visual Studio

There were errors while loading the package.

See the Error List for details.

1 Error loading Package.dtsx: Failed to decrypt protected XML node "DTS:Property" 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.

Package.dtsx 1 1

2 Information while loading Package.dstx: The package is attempting to configure from the XML file "C:TempTestPackageConfig.dtsConfig".

Package.dtsx 1 1

• Status: Open
• Question Views: 1345
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Hoiske bahu 0 points N/A #125159

Error in upgrading SSIS project to 2012 RC0

Hi there!

At first, you have to check on your Package Security ProtectionLevel since there has to be some changes if it is still set on default settings, so you have to check whether or not it is set to DontSaveSensitive if you are still having the EncryptSensitiveWithUserKey. After which, go into package configuration by enabling Package Configuration Organizer through clicking onto package design surface. 

Now, set up XML configuration file. Check the Username and Password of the FTP site. Store the configuration file and the password details of your connection string and make manual changes to. Then run your package with the modified configuration. For visualization of the process, consider the following:

Changing the Package Security ProtectionLevel.

Enabling Package Configuration Organizer.

Set up XML configuration file.

Modify the configuration and store password.

That would be all.

I hope it could help you!

About Hoiske bahu

Questions
4

Answers
9

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 02/14/2012
• Question Category: MySQL Server