Share via

ApplicationClass.LoadFromSQLServer Method

  • Article

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

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

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

Syntax

'Declaration
Public Overridable Function LoadFromSQLServer ( _
    bstrPackagePath As String, _
    bstrServerName As String, _
    bstrServerUserName As String, _
    bstrServerPassword As String, _
    bLoadNeutral As Boolean, _
    pEvents As IDTSEvents100 _
) As IDTSPackage100
'Usage
Dim instance As ApplicationClass 
Dim bstrPackagePath As String 
Dim bstrServerName As String 
Dim bstrServerUserName As String 
Dim bstrServerPassword As String 
Dim bLoadNeutral As Boolean 
Dim pEvents As IDTSEvents100 
Dim returnValue As IDTSPackage100 

returnValue = instance.LoadFromSQLServer(bstrPackagePath, _
    bstrServerName, bstrServerUserName, _
    bstrServerPassword, bLoadNeutral, _
    pEvents)

public virtual IDTSPackage100 LoadFromSQLServer(
    string bstrPackagePath,
    string bstrServerName,
    string bstrServerUserName,
    string bstrServerPassword,
    bool bLoadNeutral,
    IDTSEvents100 pEvents
)

public:
virtual IDTSPackage100^ LoadFromSQLServer(
    [InAttribute] String^ bstrPackagePath, 
    [InAttribute] String^ bstrServerName, 
    [InAttribute] String^ bstrServerUserName, 
    [InAttribute] String^ bstrServerPassword, 
    [InAttribute] bool bLoadNeutral, 
    [InAttribute] IDTSEvents100^ pEvents
)

abstract LoadFromSQLServer : 
        bstrPackagePath:string * 
        bstrServerName:string * 
        bstrServerUserName:string * 
        bstrServerPassword:string * 
        bLoadNeutral:bool * 
        pEvents:IDTSEvents100 -> IDTSPackage100  
override LoadFromSQLServer : 
        bstrPackagePath:string * 
        bstrServerName:string * 
        bstrServerUserName:string * 
        bstrServerPassword:string * 
        bLoadNeutral:bool * 
        pEvents:IDTSEvents100 -> IDTSPackage100

public function LoadFromSQLServer(
    bstrPackagePath : String, 
    bstrServerName : String, 
    bstrServerUserName : String, 
    bstrServerPassword : String, 
    bLoadNeutral : boolean, 
    pEvents : IDTSEvents100
) : IDTSPackage100

Parameters

  • bstrPackagePath
    Type: System.String
    The name and path of the package to load.
  • bstrServerName
    Type: System.String
    The name of the instance of SQL Server that the package is loaded from.
  • bstrServerUserName
    Type: System.String
    The account name used to log on to the server.
  • bstrServerPassword
    Type: System.String
    The password of the account.
  • bLoadNeutral
    Type: System.Boolean
    true to load the package as neutral threaded. false to load the package as apartment threaded.

Return Value

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

Implements

IDTSApplication100.LoadFromSQLServer(String, String, String, String, Boolean, IDTSEvents100)

See Also

Reference

ApplicationClass Class

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace