共用方式為

DTSProtectionLevel Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:
Microsoft.SqlServer.DTSRuntimeWrap.dll

Controls the handling of sensitive information in the package.

public enum class DTSProtectionLevel
public enum DTSProtectionLevel
type DTSProtectionLevel = 
Public Enum DTSProtectionLevel
Inheritance
Enum
DTSProtectionLevel

Fields

Name Value Description
DTSPL_DONTSAVESENSITIVE 0

Sensitive information is not saved in the package. The sensitive information is removed and replaced with blanks.
DTSPL_ENCRYPTSENSITIVE_USERKEY 1

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_ENCRYPTSENSITIVE_PASSWORD 2

Encrypts only sensitive information contained in the package by using a password. DPAPI is used for this encryption.
DTSPL_ENCRYPTALL_PASSWORD 3

Encrypts the entire package by using a password.
DTSPL_ENCRYPTALL_USERKEY 4

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_SERVERSTORAGE 5

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 Database-Level Roles and sysssispackages (Transact-SQL).

Remarks

For more information, see DTSProtectionLevel.

Applies to