Application.ExistsOnSqlServer Method (String, String, String, String)

 

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

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

Public Function ExistsOnSqlServer (
	packagePath As String,
	serverName As String,
	serverUserName As String,
	serverPassword As String
) As Boolean

Parameters

packagePath
Type: System.String

The package you are looking for.

serverName
Type: System.String

The name of the instance of SQL Server to search for the package.

serverUserName
Type: System.String

The user name to authenticate against the instance of SQL Server.

serverPassword
Type: System.String

The password for the specified serverUserName.

Return Value

Type: System.Boolean

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

The following code example creates a SQL Server folder, verifies that it exists, and then removes the folder and rechecks its existence. It also saves a package and verifies that the package was saved using the ExistsOnSqlServer method.

Sub Main(ByVal args() As String)
            ' The variable pkg points to the location
            ' of the ExecuteProcess package sample 
            ' that is installed with the SSIS samples.
            Dim p As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx" 

            Dim app As Application =  New Application() 

            ' Create a folder on SQL Server in the msdb database.
            app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", Nothing, Nothing)

            ' Verify that the folder exists by using ExistsOnSqlServer method.
            Dim folderExists As Boolean =  app.FolderExistsOnSqlServer("myNewFolder","yourserver",Nothing,Nothing) 
            Console.WriteLine("Folder exists? {0}", folderExists)

            ' Load a package and save it.
            Dim pkg As Package =  app.LoadPackage(p,Nothing) 
            app.SaveToSqlServerAs(pkg, Nothing, "newPkg", "yourserver", Nothing, Nothing)

            ' Verify that the package was saved.
            Dim packageExists As Boolean =  app.ExistsOnSqlServer("newPkg","yourserver",Nothing,Nothing) 
            Console.WriteLine("Package exists? {0}", packageExists)

            'Remove the folder.
            app.RemoveFolderFromSqlServer("myNewFolder", "yourserver", Nothing, Nothing)

            ' Verify that the folder was removed by using the ExistsOnSqlServer method.
            folderExists = app.FolderExistsOnSqlServer("myNewFolder", "yourserver", Nothing, Nothing)
            Console.WriteLine("Folder exists? {0}", folderExists)
End Sub

Sample Output:

Folder exists? True

Package exists? True

Folder exists? False

Return to top
Show: