共用方式為

IDTSApplication100.LoadFromSQLServer 方法

  • 發行項

此 API 支援 SQL Server 2012 基礎結構，但無法直接從您的程式碼使用。

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

命名空間：  Microsoft.SqlServer.Dts.Runtime.Wrapper
組件：  Microsoft.SqlServer.DTSRuntimeWrap (在 Microsoft.SqlServer.DTSRuntimeWrap.dll 中)

語法

'宣告
Function LoadFromSQLServer ( _
    bstrPackagePath As String, _
    bstrServerName As String, _
    bstrServerUserName As String, _
    bstrServerPassword As String, _
    bLoadNeutral As Boolean, _
    pEvents As IDTSEvents100 _
) As IDTSPackage100
'用途
Dim instance As IDTSApplication100 
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)

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

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

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

參數

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

傳回值

型別：Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackage100
The package that was loaded.

請參閱

參考

IDTSApplication100 介面

Microsoft.SqlServer.Dts.Runtime.Wrapper 命名空間