Export (0) Print
Expand All

Application.LoadFromDtsServer Method

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
)
public Package LoadFromDtsServer (
	String sPackagePath, 
	String sServerName, 
	IDTSEvents pEvents
)
public function LoadFromDtsServer (
	sPackagePath : String, 
	sServerName : String, 
	pEvents : IDTSEvents
) : Package

Parameters

sPackagePath

The fully qualified path of the package.

sServerName

The server where the package is stored.

pEvents

An IDTSEvents interface.

Return Value

A Package object.

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}

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft