LoadFromSqlServer Method

Application::LoadFromSqlServer Method (String^, String^, String^, String^, IDTSEvents^)

 

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:
Package^ LoadFromSqlServer(
	String^ packagePath,
	String^ serverName,
	String^ serverUserName,
	String^ serverPassword,
	IDTSEvents^ events
)

Parameters

packagePath
Type: System::String^

The name and path of the package to load.

serverName
Type: System::String^

The name of the instance of SQL Server that the package is loaded from.

serverUserName
Type: System::String^

The account name used to log on to the server.

serverPassword
Type: System::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

Return to top
Show:
© 2016 Microsoft