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:
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 SQL Server login name if you use SQL Server Authentication to log into the server; otherwise, nullptr if you use Windows Authentication.
serverPassword
Type: System::String
The SQL Server login password if you use SQL Server Authentication to log into the server; otherwise, nullptr if you use Windows Authentication.
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