Application.FolderExistsOnDtsServer(String, String) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 bool FolderExistsOnDtsServer(System::String ^ sFolderName, System::String ^ sServerName);

public bool FolderExistsOnDtsServer (string sFolderName, string sServerName);

member this.FolderExistsOnDtsServer : string * string -> bool

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

Parameters

sFolderName: 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: String

The name of the server to search for the package.

Returns

Boolean

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

Examples

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

class PackageTest  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            Package p = app.LoadPackage(pkg, null);  

            String folderName = @"\File System\myFolder";  
            String serverName = "yourserver";  
            Boolean folderExists = app.FolderExistsOnDtsServer(folderName, serverName);  
            Console.WriteLine("Folder exists? " + folderExists);  
        }  
    }

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

Applies to

Share via