Application.LoadFromDtsServer(String, String, IDTSEvents) Metode

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Memuat paket dari server yang ditentukan.

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

Parameter

sPackagePath

String

Jalur paket yang sepenuhnya memenuhi syarat.

sServerName

String

Server tempat paket disimpan.

pEvents

IDTSEvents

Antarmuka IDTSEvents .

Mengembalikan

Package

Objek Package.

Contoh

Contoh kode berikut mengambil dua paket, bernama myp1Package dan myp2Package, yang sebelumnya disimpan ke folder Sistem File dari layanan Layanan Integrasi.

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  

Contoh Output:

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

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