Application.FolderExistsOnDtsServer Method (String, String)

 

Returns a Boolean that indicates whether the specified folder already exists on the file system.

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

Public Function FolderExistsOnDtsServer (
	sFolderName As String,
	sServerName As String
) As Boolean

Parameters

sFolderName
Type: System.String

The name of the folder you are looking for. For example, to see if a folder name myFolder exists under the File System folder, use the escaped string, @"\File System\myFolder".

sServerName
Type: System.String

The name of the server to search for the package.

Return Value

Type: System.Boolean

true if the folder specified exists on the server; false if the folder does not exist.

The following code example queries the File System to determine whether a folder that was created previously, named myFolder, exists.

Class PackageTest
        Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim p As Package =  app.LoadPackage(pkg,Nothing) 

            Dim folderName As String =  "\File System\myFolder" 
            Dim serverName As String =  "yourserver" 
            Dim folderExists As Boolean =  app.FolderExistsOnDtsServer(folderName,serverName) 
            Console.WriteLine("Folder exists? " + folderExists)
        End Sub
End Class

Sample Output:

Folder exists? True

Return to top
Show: