SSIS Default Package Settings

  • Does anyone know how to change the default package setting "ProtectionLevel" so that I do not have to set it to ServerStorage everytime I create a package. Can not seem to find it in the Tools > Options and do not know where else to look.

  • dwilliscp (3/4/2013)


    Does anyone know how to change the default package setting "ProtectionLevel" so that I do not have to set it to ServerStorage everytime I create a package. Can not seem to find it in the Tools > Options and do not know where else to look.

    Don't think you can. But you can create your own templates and use those instead when creating a package. See here for details.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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