Post reply

Error moving from test to production server

  • August 15, 2013 at 8:34 am

    #277039

    Hello,

    I am receiving this error type always, when i move my package from test server to production server any idea abt it and wht to do..

    Error1Error loading package1.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.

    Thanks

    Shaun

  • August 15, 2013 at 8:39 am

    #1641827

    I think this is to do with the "package protection level" when you are saving the package.

  • August 15, 2013 at 8:41 am

    #1641828

    so what should i do.. I am always saving the connection password but it is saved as "EncryptSensitiveWithUserKey"..

    So wht should i do to make it run in the prouction..

  • August 15, 2013 at 11:10 am

    #1641873

    Shaun2012 (8/15/2013)

    Hello,

    I am receiving this error type always, when i move my package from test server to production server any idea abt it and wht to do..

    Error1Error loading package1.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.

    Thanks

    Shaun

    Change the ProtectionLevel. If you're encrypting with user key then another user opening it would get error messages. You can encrypt with a password, then you just have to remember the password. Or You can save pwd and user info in a config file or a config table in a sql database and set it to not save sensitive data.

    Look in BOL or search for SSIS configuration file. It's been over a year since I've created an SSIS package it's a bit foggy to me.

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

  • August 15, 2013 at 12:27 pm

    #1641902

    thanks.. i will test it.let u know..

    shaun..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply