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.


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

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