DTSProtectionLevel Enumeration

 

This API supports the product infrastructure and is not intended to be used directly from your code.

Controls the handling of sensitive information in the package.

Namespace:   Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

public enum DTSProtectionLevel

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

For more information, see DTSProtectionLevel.

Return to top
Show: