Application.LoadFromDtsServer(String, String, IDTSEvents) 方法

定义

命名空间:

Microsoft.SqlServer.Dts.Runtime

程序集:

Microsoft.SqlServer.ManagedDTS.dll

从指定的服务器加载包。

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}