Post reply

Security issues with package configs and "master" packages

  • April 4, 2008 at 9:16 am

    #124753

    Hi

    I am using a package configuration file to store my sql login/password. When I schedule the packages individually through SQL Server agent they run fine, but when I create a "master package" which calls the detailed packages, it fails when I try and run it through SQL Server agent.

    I get a long error message "....... Failed to decrypt protected XML node "Password".......etc etc

    Thanks in advance!!!

    Chris

  • April 22, 2008 at 5:51 pm

    #805826

    Hi Chris,

    I use similar "master package". I think I can help you, but I need more information.

    Do you use your "master package" (with passwords) as "parent" package? What value do you have for the "ProtectionLevel" property in "child" package and in "parent" package? Did you set your "child" package configuration to the "Parent package variable" type?

Viewing 2 posts - 1 through 1 (of 1 total)

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