通过

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 命名空间