Excluding Sensitive Information from the Package
Integration Services identifies the properties containing sensitive data (i.e., passwords or connection strings) in a package and sets the sensitive attribute of these properties. Integration Services identifies the sensitive properties automatically and doesn’t let you change any sensitive attributes of these properties. However, you can specify the properties you want to be treated as sensitive for your custom-built SSIS components.
You can opt not to save sensitive data in the package. The list of options is available in the ProtectionLevel property of the package, shown in Figure 7-1. When you choose the DontSaveSensitive option, the sensitive information is removed from the package when saved ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
