locked
Package Configuration + Environment variable RRS feed

  • Question

  • We are using Package configuration with environment variables. The problem we are having that if we try to open project from other PC (PC 2) it gives the error:

     

    Error    1            Error loading F0005.dtsx: 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.              z:\visual studio 2005\projects\sales data mart\extract to staging area\F0005.dtsx            1            1         

     

    We are using environment variable named DWConfig and have configured correct path in each PC. If  we edit package configuration in PC 2 and go thru the same procedures without any amendments the errors is removed for that PC and if, again we OPEN that project in PC 1 it gives same error and if we go thru package configuration wizard again error is removed.

     

    Can any one tell me is there any solution of that problem?

     

    Note: Our project is saved on server  (neither PC 1 nor PC 2)

    regards,

    Anas.

    Monday, July 17, 2006 2:06 PM

Answers

  •  

    We are using Package configuration with environment variables. The problem we are having that if we try to open project from other PC (PC 2) it gives the error:

     

    Error    1            Error loading F0005.dtsx: 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.              z:\visual studio 2005\projects\sales data mart\extract to staging area\F0005.dtsx            1            1         

     

    We are using environment variable named DWConfig and have configured correct path in each PC. If  we edit package configuration in PC 2 and go thru the same procedures (Package Configuration Wizard) without any amendments the errors is removed for that PC and if, again we OPEN that project in PC 1 it gives same error and if we go thru package configuration wizard again error is removed.

     

    Can any one tell me is there any solution of that problem?

     

    Note: Our project is saved on server  (neither PC 1 nor PC 2)

    regards,

    Anas.

    Monday, July 17, 2006 3:16 PM
  • I have got the answer from:

    http://support.microsoft.com/kb/904800/

     

    thanks,

    Anas

    Monday, July 17, 2006 3:40 PM

All replies

  •  

    We are using Package configuration with environment variables. The problem we are having that if we try to open project from other PC (PC 2) it gives the error:

     

    Error    1            Error loading F0005.dtsx: 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.              z:\visual studio 2005\projects\sales data mart\extract to staging area\F0005.dtsx            1            1         

     

    We are using environment variable named DWConfig and have configured correct path in each PC. If  we edit package configuration in PC 2 and go thru the same procedures (Package Configuration Wizard) without any amendments the errors is removed for that PC and if, again we OPEN that project in PC 1 it gives same error and if we go thru package configuration wizard again error is removed.

     

    Can any one tell me is there any solution of that problem?

     

    Note: Our project is saved on server  (neither PC 1 nor PC 2)

    regards,

    Anas.

    Monday, July 17, 2006 3:16 PM
  • I have got the answer from:

    http://support.microsoft.com/kb/904800/

     

    thanks,

    Anas

    Monday, July 17, 2006 3:40 PM