Application.LoadFromDtsServer(String, String, IDTSEvents) Méthode

Référence

Définition

Espace de noms:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Certaines informations portent sur la préversion du produit qui est susceptible d’être en grande partie modifiée avant sa publication. Microsoft exclut toute garantie, expresse ou implicite, concernant les informations fournies ici.

Charge un package à partir du serveur spécifié.

public:
 Microsoft::SqlServer::Dts::Runtime::Package ^ LoadFromDtsServer(System::String ^ sPackagePath, System::String ^ sServerName, Microsoft::SqlServer::Dts::Runtime::IDTSEvents ^ pEvents);

public Microsoft.SqlServer.Dts.Runtime.Package LoadFromDtsServer (string sPackagePath, string sServerName, Microsoft.SqlServer.Dts.Runtime.IDTSEvents pEvents);

member this.LoadFromDtsServer : string * string * Microsoft.SqlServer.Dts.Runtime.IDTSEvents -> Microsoft.SqlServer.Dts.Runtime.Package

Public Function LoadFromDtsServer (sPackagePath As String, sServerName As String, pEvents As IDTSEvents) As Package

Paramètres

sPackagePath: String

Chemin d'accès complet du package.

sServerName: String

Serveur où est stocké le package.

pEvents: IDTSEvents

Interface IDTSEvents.

Retours

Package

Objet Package.

Exemples

L’exemple de code suivant récupère deux packages nommés et myp1Packagemyp2Package, précédemment enregistrés dans le dossier Système de fichiers du service Integration Services.

static void Main(string[] args)  
        {  
            Application app = new Application();  
            // Load the packages.  
            Package p1 = app.LoadFromDtsServer(@"File System\myp1Package", "yourserver", null);  
            Package p2 = app.LoadFromDtsServer(@"File System\myp2Package", "yourserver", null);  
            // Retrieve the ID (GUID) from the packages for display.  
            String p1_ID = p1.ID;  
            String p2_ID = p2.ID;  
            Console.WriteLine("ID for myp1Package = " + p1_ID);  
            Console.WriteLine("ID for myp2Package = " + p2_ID);  
        }

Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            ' Load the packages.  
            Dim p1 As Package =  app.LoadFromDtsServer("File System\myp1Package","yourserver",Nothing)   
            Dim p2 As Package =  app.LoadFromDtsServer("File System\myp2Package","yourserver",Nothing)   
            ' Retrieve the ID (GUID) from the packages for display.  
            Dim p1_ID As String =  p1.ID   
            Dim p2_ID As String =  p2.ID   
            Console.WriteLine("ID for myp1Package = " + p1_ID)  
            Console.WriteLine("ID for myp2Package = " + p2_ID)  
End Sub

Exemple de sortie :

ID for myp1Package = {598607C7-9C17-487D-A545-8D1C35FBF6E2}

ID for myp2Package = {F0D2E396-A6A5-42AE-9467-04CE946A810C}

S’applique à

Partager via