Application.LoadFromDtsServer(String, String, IDTSEvents) Метод

Определение

Загружает пакет с указанного сервера.

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

Параметры

sPackagePath
String

Полный путь к пакету.

sServerName
String

Сервер, на котором хранится пакет.

pEvents
IDTSEvents

Интерфейс IDTSEvents.

Возвращаемое значение

Package

Объект Package.

Примеры

В следующем примере кода извлекаются два пакета с именами myp1Package и, myp2Package, которые ранее сохранялись в папке файловой системы службы 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  

Образец вывода:

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

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

Применяется к