SSIS Package Security

• dave-dj

  SSChampion

  Points: 11297

  More actions

  November 10, 2008 at 2:46 am

  #195998

  Does anyone know how if it's possible to have the package security set to EncryptAllWithUserKey or EncryptAllWithPassword, but when deployed to an SQL Server, have the package security default to ServerStorage ?

  _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 12, 2008 at 9:08 am

  #897594

  The package protection level stays at what you set it to when you edit it. AFAIK, there's no way to change it as it's deployed.

  Greg