Package.LoadUserCertificateByHash(Byte[]) Méthode

  • Référence

Définition

Espace de noms:
Microsoft.SqlServer.Dts.Runtime
Assembly:
Microsoft.SqlServer.ManagedDTS.dll

Charge le certificat du package en fonction du hachage du certificat.

public:
 void LoadUserCertificateByHash(cli::array <System::Byte> ^ certHash);
public void LoadUserCertificateByHash (byte[] certHash);
member this.LoadUserCertificateByHash : byte[] -> unit
Public Sub LoadUserCertificateByHash (certHash As Byte())

Paramètres

certHash
Byte[]

Tableau d'octets qui contient le hachage du certificat pour le package.

Exemples

L’exemple de code suivant montre la syntaxe de chargement d’un certificat utilisateur à l’aide du hachage de certificat.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace Package_API  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            Package pkg = new Package();  

            pkg.Name = ("Cool Test on Loading Certificates");  
            pkg.LoadUserCertificateByName("\"VeriSign, Inc.\", VeriSign Trust Network, \"www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD(c)98\", Persona Not Validated, Digital ID Class 1 - Microsoft, <name>, <alias>");  

    pkg.LoadUserCertificateByHash(pkg.CertificateObject.GetCertHash());  

            // Save signed package  to change_this.dtsx  
            app.SaveToXml("change_this.dtxs", pkg, null);  
            app.CheckSignatureOnLoad = false;  
            pkg = app.LoadPackage("change_this.dtxs", null);  
            DTSSignatureStatus dss = pkg.CheckSignature();  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Class Program  
    Shared Sub Main(ByVal args() As String)   
        Dim app As New Application()  
        Dim pkg As New Package()  

        pkg.Name = "Cool Test on Loading Certificates"  
        pkg.LoadUserCertificateByName("""VeriSign, Inc."", VeriSign Trust Network, ""www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD(c)98"", Persona Not Validated, Digital ID Class 1 - Microsoft, <name>, <alias>")  

        pkg.LoadUserCertificateByHash(  
            pkg.CertificateObject.GetCertHash())  

        ' Save signed package  to change_this.dtsx  
        app.SaveToXml("change_this.dtxs", pkg, Nothing)  
        app.CheckSignatureOnLoad = False  
        pkg = app.LoadPackage("change_this.dtxs", Nothing)  
        Dim dss As DTSSignatureStatus = pkg.CheckSignature()  
    End Sub  
End Class

Remarques

Pour obtenir le code de hachage d’octet d’un certificat, vous pouvez utiliser la méthode X509Certificate.GetCertHash à partir de l’espace de noms System.Security.Cryptography.X509Certificates.

S’applique à