Post reply

SSIS Package EncryptSensitiveWithUserKey BUT user no longer exists

  • February 6, 2012 at 9:23 am

    #254956

    Hi all,

    I have a SSIS package which was created by someone else which has the ProtectionLevel set to EncryptSensitiveWithUserKey.

    I now need to edit the package, which I can do BUT cannot save as it is encrypted with another users key, the issue being here, is that the user who created it has subsequently had the account deleted.

    Is there anyway to edit this package under another users account?

    Thanks in advance.

    dazmaul

  • February 6, 2012 at 9:28 am

    #1443258

    Once you open the package to edit it, can you not change the package Protectionlevel to EncryptSensitivewithpassword and give your own password.

    I haven't been in this scenario, but trying to think a way out..

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • February 6, 2012 at 10:19 am

    #1443298

    Bru, thanks for the quick response.

    I can change the ProtectionLevel BUT I cannot overwrite the same package, I need to save it out as something else.

    I think this is my only option. The package itself contains a number of other packages which I will need to do the same with and then rebuild in another project.

    Thanks again.

  • February 6, 2012 at 11:09 am

    #1443344

    Yes sadly that is the only option...

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

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

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