Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DTSSignatureStatus Enumeration

 

Applies To: SQL Server 2016 Preview

Describes the status of the digital signature.

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

public enum DTSSignatureStatus

Member nameDescription
Good

The signature is valid.

Invalid

The signature is not valid.

NotPresent

The signature is not present.

Untrusted

The signature is from an untrusted source.

A package can be signed with a digital signature. By using a digital signature, you can help ensure that only packages from trusted sources are opened and run. However, to ensure that Integration Services checks the digital signature when it loads a package, you must also do at least one of the following steps:

  • Set the value of a registry entry.

  • Set a command prompt option for the dtexec utility (dtexec.exe).

  • Set a property in SQL Server Data Tools. 

  • Set a property in your code when you load or run packages programmatically. For example, the CheckSignatureOnLoad property of the Application class determines whether the signature is checked.

For more information, see Identify the Source of Packages with Digital Signatures.

System_CAPS_importantImportant

When configured to check the signature of the package, Integration Services only checks whether the digital signature is present, is valid, and is from a trusted source. Integration Services does not check whether the package has been changed.

Legacy Code 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("Status not valid: found " + dss + ", expected " + expectedStatus);
}
Return to top

Community Additions

Show:
© 2015 Microsoft