Share via

ApplicationClass.ExistsOnSQLServer Method

  • Article

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

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
Public Overridable Function ExistsOnSQLServer ( _
    bstrPackagePath As String, _
    bstrServerName As String, _
    bstrServerUserName As String, _
    bstrServerPassword As String _
) As Boolean
'Usage
Dim instance As ApplicationClass 
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)

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

public:
virtual 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  
override ExistsOnSQLServer : 
        bstrPackagePath:string * 
        bstrServerName:string * 
        bstrServerUserName:string * 
        bstrServerPassword:string -> bool

public 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

Implements

IDTSApplication100.ExistsOnSQLServer(String, String, String, String)

See Also

Reference

ApplicationClass Class

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace