Share via

IDTSApplication100.ExistsOnSQLServer Method

  • Article

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

Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.

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

Syntax

'Declaration
Function ExistsOnSQLServer ( _
    bstrPackagePath As String, _
    bstrServerName As String, _
    bstrServerUserName As String, _
    bstrServerPassword As String _
) As Boolean
'Usage
Dim instance As IDTSApplication100 
Dim bstrPackagePath As String 
Dim bstrServerName As String 
Dim bstrServerUserName As String 
Dim bstrServerPassword As String 
Dim returnValue As Boolean 

returnValue = instance.ExistsOnSQLServer(bstrPackagePath, _
    bstrServerName, bstrServerUserName, _
    bstrServerPassword)

bool ExistsOnSQLServer(
    string bstrPackagePath,
    string bstrServerName,
    string bstrServerUserName,
    string bstrServerPassword
)

bool ExistsOnSQLServer(
    [InAttribute] String^ bstrPackagePath, 
    [InAttribute] String^ bstrServerName, 
    [InAttribute] String^ bstrServerUserName, 
    [InAttribute] String^ bstrServerPassword
)

abstract ExistsOnSQLServer : 
        bstrPackagePath:string * 
        bstrServerName:string * 
        bstrServerUserName:string * 
        bstrServerPassword:string -> bool

function ExistsOnSQLServer(
    bstrPackagePath : String, 
    bstrServerName : String, 
    bstrServerUserName : String, 
    bstrServerPassword : String
) : boolean

Parameters

  • bstrPackagePath
    Type: System.String
    The package you are looking for.
  • bstrServerName
    Type: System.String
    The name of the instance of SQL Server to search for the package.
  • bstrServerUserName
    Type: System.String
    The user name to authenticate against the instance of SQL Server.
  • bstrServerPassword
    Type: System.String
    The password for the specified bstrServerUserName.

Return Value

Type: System.Boolean
true if the package exists on the specified instance of SQL Server. false if the package does not exist.

See Also

Reference

IDTSApplication100 Interface

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace