Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Package Security Expand / Collapse
Author
Message
Posted Monday, November 10, 2008 2:46 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 5:38 AM
Points: 405, Visits: 1,136
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)
Post #599704
Posted Wednesday, November 12, 2008 9:08 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 3:18 PM
Points: 4,065, Visits: 5,284
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
Post #601465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse