IDTSApplication100.SaveToSQLServerAs Method

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

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

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

Syntax

'Declaration
Sub SaveToSQLServerAs ( _
    pPackage As IDTSPackage100, _
    pEvents As IDTSEvents100, _
    bstrPackagePath As String, _
    bstrServerName As String, _
    bstrServerUserName As String, _
    bstrServerPassword As String _
)
'Usage
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
)

Parameters

• pPackage
  Type: Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackage100
  The package to save.

• pEvents
  Type: Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSEvents100
  An IDTSEvents100 interface.

• bstrPackagePath
  Type: 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
  Type: System.String
  The name of the instance of SQL Server.

• bstrServerUserName
  Type: System.String
  The name of the account used to log on to the instance of SQL Server.

• bstrServerPassword
  Type: System.String
  The password of the user account.

See Also

Reference

IDTSApplication100 Interface

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace