Enumerazione DTSProtectionLevel
Questa API supporta l'infrastruttura SQL Server 2012 e non può essere utilizzata direttamente dal codice.
Controls the handling of sensitive information in the package.
Spazio dei nomi Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly: Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)
Sintassi
'Dichiarazione
Public Enumeration DTSProtectionLevel
'Utilizzo
Dim instance As DTSProtectionLevel
public enum DTSProtectionLevel
public enum class DTSProtectionLevel
type DTSProtectionLevel
public enum DTSProtectionLevel
Membri
| Nome membro | Descrizione | |
|---|---|---|
| DTSPL_DONTSAVESENSITIVE | Sensitive information is not saved in the package. The sensitive information is removed and replaced with blanks. | |
| DTSPL_ENCRYPTALL_PASSWORD | Encrypts the entire package by using a password. | |
| DTSPL_ENCRYPTALL_USERKEY | Encrypts the entire package by using keys based on the user profile. Only the same user using the same profile can load the package. | |
| DTSPL_ENCRYPTSENSITIVE_PASSWORD | Encrypts only sensitive information contained in the package by using a password. DPAPI is used for this encryption. | |
| DTSPL_ENCRYPTSENSITIVE_USERKEY | Encrypts sensitive properties only by using keys based on the current user. Only the same user using the same profile can load the package. If a different user opens the package, the sensitive information is replaced with blanks. DPAPI is used for this encryption. | |
| DTSPL_SERVERSTORAGE | Encrypts the package within a SQL Server msdb database. This option is supported only when a package is saved to SQL Server. It is not supported when a package is saved to the File System. The access control of who can decrypt the package is controlled by SQL Server database roles. For more information, see Ruoli a livello di database and sysssispackages (Transact-SQL). |
Osservazioni
For more information, see DTSProtectionLevel.