Export (0) Print
Expand All

Application.LoadFromSqlServer Method

Loads a package from SQL Server by specifying the server name, user name, and password.

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

public function LoadFromSqlServer(
	packagePath : String, 
	serverName : String, 
	serverUserName : String, 
	serverPassword : String, 
	events : IDTSEvents
) : Package

Parameters

packagePath
Type: String
The name and path of the package to load.
serverName
Type: String
The name of the instance of SQL Server that the package is loaded from.
serverUserName
Type: String
The account name used to log on to the server.
serverPassword
Type: String
The password of the account.
events
Type: Microsoft.SqlServer.Dts.Runtime.IDTSEvents
An IDTSEvents interface.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.Package
The package that was loaded.

The following code example loads a sample package, which was previously saved to the File System.

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

Sample Output:

Creation Date = 5/5/2003 5:46:00 PM

Community Additions

ADD
Show:
© 2014 Microsoft