Package.CheckSignatureOnLoad Property

Gets or sets a value that indicates whether the digital signature is checked when a package is loaded from XML.

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

public bool CheckSignatureOnLoad { get; set; }
/** @property */
public boolean get_CheckSignatureOnLoad ()

/** @property */
public void set_CheckSignatureOnLoad (boolean value)

public function get CheckSignatureOnLoad () : boolean

public function set CheckSignatureOnLoad (value : boolean)

Property Value

A Boolean that indicates if the digital signature is checked when the package is loaded. A value of true indicates that the digital signature is validated when the package is loaded. The default value is false.

If CheckSignatureOnLoad is enabled, all packages are examined for a digital signature when they are loaded. The signature is validated by checking the CertificateContext property of the package. If the certificate is validated, the package is opened without any messages to the user. If the certificate is not trusted, a warning message appears and allows you to interactively decide if you want to trust the contents.

The following example loads a package, and then retrieves and displays the CheckSignatureOnLoad property.

class PackageTest
        static void Main(string[] args)
            // The variable pkg points to the location
            // of the ExecuteProcess package sample 
            // that is installed with the samples.
            string pkg = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
            Application app = new Application();
            Package p = app.LoadPackage(pkg, null);
            // Once the package is loaded, this sample can
            // query on several properties
            Boolean checkSig = p.CheckSignatureOnLoad;
            Console.WriteLine("CheckSignatureOnLoad = " + checkSig);

Sample Output:

CheckSignatureOnLoad = True

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

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

Target Platforms

Community Additions