共用方式為

IDTSApplication100.SaveToSQLServerAs 方法

  • 發行項

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

Saves a package to an instance of SQL Server with a new name.

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

語法

'宣告
Sub SaveToSQLServerAs ( _
    pPackage As IDTSPackage100, _
    pEvents As IDTSEvents100, _
    bstrPackagePath As String, _
    bstrServerName As String, _
    bstrServerUserName As String, _
    bstrServerPassword As String _
)
'用途
Dim instance As IDTSApplication100 
Dim pPackage As IDTSPackage100 
Dim pEvents As IDTSEvents100 
Dim bstrPackagePath As String 
Dim bstrServerName As String 
Dim bstrServerUserName As String 
Dim bstrServerPassword As String

instance.SaveToSQLServerAs(pPackage, _
    pEvents, bstrPackagePath, bstrServerName, _
    bstrServerUserName, bstrServerPassword)

void SaveToSQLServerAs(
    IDTSPackage100 pPackage,
    IDTSEvents100 pEvents,
    string bstrPackagePath,
    string bstrServerName,
    string bstrServerUserName,
    string bstrServerPassword
)

void SaveToSQLServerAs(
    [InAttribute] IDTSPackage100^ pPackage, 
    [InAttribute] IDTSEvents100^ pEvents, 
    [InAttribute] String^ bstrPackagePath, 
    [InAttribute] String^ bstrServerName, 
    [InAttribute] String^ bstrServerUserName, 
    [InAttribute] String^ bstrServerPassword
)

abstract SaveToSQLServerAs : 
        pPackage:IDTSPackage100 * 
        pEvents:IDTSEvents100 * 
        bstrPackagePath:string * 
        bstrServerName:string * 
        bstrServerUserName:string * 
        bstrServerPassword:string -> unit

function SaveToSQLServerAs(
    pPackage : IDTSPackage100, 
    pEvents : IDTSEvents100, 
    bstrPackagePath : String, 
    bstrServerName : String, 
    bstrServerUserName : String, 
    bstrServerPassword : String
)

參數

  • bstrPackagePath
    型別：System.String
    The path and new name to assign to the package. The parameter bstrPackagePath is in the format of \\folder\\packageName. If bstrPackagePath is specified without an existing folder, the package will be saved with this parameter as its new name.
  • bstrServerName
    型別：System.String
    The name of the instance of SQL Server.
  • bstrServerUserName
    型別：System.String
    The name of the account used to log on to the instance of SQL Server.
  • bstrServerPassword
    型別：System.String
    The password of the user account.

請參閱

參考

IDTSApplication100 介面

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