DTSSignatureStatus Enumeration

Article
12/03/2008

Describes the digital signature.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Enumeration DTSSignatureStatus

public enum DTSSignatureStatus

public enum class DTSSignatureStatus

public enum DTSSignatureStatus

public enum DTSSignatureStatus

Members

Member name	Description
Good	The signature has been checked and is valid.
Invalid	The signature has been checked and is invalid.
NotPresent	The signature is not present.
Untrusted	The signature is from an untrusted source.

Remarks

A package can be signed with a digital signature and encrypted with a password or a user key. Using a digital signature ensures that only packages from trusted sources are opened and run. The package includes properties that enable you to name the certificate and to ensure the digital signature is always checked when the package loads. The Application and Package classes have a Boolean property of CheckSignatureOnLoad that determines whether the signature is checked. For more information, see Security Considerations for Integration Services.

Example

The following code example specifies through the Application class that the package will have its signature checked on load.

Application app = new Application();
app.CheckSignatureOnLoad = CheckSignatureOnLoad;
pkg = app.LoadPackage(mysavedPackagePath, null);
DTSSignatureStatus expectedStatus = DTSSignatureStatus.Good;

DTSSignatureStatus dss = pkg.CheckSignature();
if (dss != expectedStatus)
{
    Console.WriteLine("Invalid status: found " + dss + ", expected " + expectedStatus);
}

Dim app As Application =  New Application() 
app.CheckSignatureOnLoad = CheckSignatureOnLoad
pkg = app.LoadPackage(mysavedPackagePath, Nothing)
Dim expectedStatus As DTSSignatureStatus =  DTSSignatureStatus.Good 
 
Dim dss As DTSSignatureStatus =  pkg.CheckSignature() 
If dss <> expectedStatus Then
    Console.WriteLine("Invalid status: found " + dss + ", expected " + expectedStatus)
End If

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms