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.

No code example is currently available or this language may not be supported.

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:
© 2015 Microsoft