Error in upgrading SSIS project to 2012 RC0

Asked By 0 points N/A Posted on -

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.

Error Details Report

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

Answered By 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.

Changing the Package Security ProtectionLevel

Enabling Package Configuration Organizer.

Enabling Package Configuration Organizer

Set up XML configuration file.

Set up XML configuration file

Modify the configuration and store password.

Modify the configuration and store password

That would be all.

I hope it could help you!

Login/Register to Answer

Related Questions