Application.LoadFromDtsServer Method (String, String, IDTSEvents)


Loads a package from the specified server.

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public Package LoadFromDtsServer(
	string sPackagePath,
	string sServerName,
	IDTSEvents pEvents


Type: System.String

The fully qualified path of the package.

Type: System.String

The server where the package is stored.

Type: Microsoft.SqlServer.Dts.Runtime.IDTSEvents

An IDTSEvents interface.

The following code example retrieves two packages, named myp1Package and myp2Package, which were previously saved to the File System folder of the Integration Services service.

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);

Sample Output:

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

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

Return to top