SSIS Package Security

  • 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)

  • 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

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

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