Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B

When and why does this error message appear..

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

are you using package configurations? if so , how are they being stored (db, XML file ect.)

what is your ProtectionLevel set to on your package properties?

how is the package being run? (debug, SqlAgent, execcute w/o debug , command line ect.)

|||

I have a master package which is calling other packages...I just opened to set some package configuration but did not set and then it's coming out with this message when i try to open my master package but is running fine even if comes out with this message...

|||

what is the ProtectionLevel property set to on the children and parent? Right click properties -> ProtectionLevel)

it appears that when you are opening the package it cannot decrypt the sensitive information.

This often occurs when developing on one box and promoting to another.

|||

my protection leve is set to EncryptSensitiveWithUserKey on both parent and child.

|||As Ryan wrote, this error may occur when moving from one box to another - this protection level uses Windows Data Protection API (DPAPI), which automatically encrypts secrets with user key, but is limited in that it obviously allows only original user to decrypt secrets, and (less known) it only works on original computer only, unless you are using Roadmin Profile.

If you need to move packages to other computers, or execute them under different user account - use other protection levels. See Books Online for details.

FAct TABLE LOOKUPs data

Hi,

Please help me out in loading the fact tables

I had used lookup on DIM table to get my SUK and if I use union transformation to get the out put from each lookup and then loading the data with some condition the data in my fact is not loading in a proper format.

The union transformation is splitting the out put in to different records

Please do inform me about which transformation should be used to get the data from lookup tables.

Or please do inform me the approach to load the fact table in SSIS.

I’m basically INFORMATICA resource and I’m implementing in terms of INFORMATICA

First of all, In SSIS you don't link ports(columns) separately; you link component input and outputs. The Dataflow should look like:

Source Component -->LKP1(get Dim1 SUK) -->LKP2(get Dim2 SUK) -->LKn(getDimn SUK) ...-->Destination Component

Notice you may want to configure the Lookup error output to either redirect or ignore errors as this component treats the no matches as errors.

In the first page of this forum there is a webcast that shows a similar approach:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=534505&SiteID=1

Please post back if something is not clear.

|||

Thank you for that information.

please do clarify me on the approach i had taken

the dataflow in my mapping is :

Source Component >LKP1 > LKP2 > Union Component > SCD Component > Destination Component.

i know the union component is a problem in my mapping but instead of union what component do i use. i'm trying to find out this solution.

or if possible give me your approach for fact tale load with lookup components

Thank you

|||Instead of a UNION, try connecting the output from Lookup 1 to Lookup 2 directly. If you do that, you don't need a union.|||

Sheikh Mohammed wrote:

Thank you for that information.

please do clarify me on the approach i had taken

the dataflow in my mapping is :

Source Component >LKP1 > LKP2 > Union Component > SCD Component > Destination Component.

i know the union component is a problem in my mapping but instead of union what component do i use. i'm trying to find out this solution.

or if possible give me your approach for fact tale load with lookup components

Thank you

AS John says, you don't need the UNION all component at all because you have single pipeline; that is the same concept that in Informatica I belive