Application.ExistsOnDtsServer(String, String) Метод

Определение

Пространство имен:

Microsoft.SqlServer.Dts.Runtime

Сборка:

Microsoft.SqlServer.ManagedDTS.dll

Возвращает логическое значение, указывающее, существует ли указанный пакет в службе Integration Services.

public:
 bool ExistsOnDtsServer(System::String ^ sPackagePath, System::String ^ sServerName);

public bool ExistsOnDtsServer (string sPackagePath, string sServerName);

member this.ExistsOnDtsServer : string * string -> bool

Public Function ExistsOnDtsServer (sPackagePath As String, sServerName As String) As Boolean

Параметры

sPackagePath

String

Полный путь к пакету.

sServerName

String

Имя сервера, на котором надо осуществлять поиск пакета.

Возвращаемое значение

Boolean

Значение true, если пакет, указанный на sPackagePath сервере с именем sServerName; в противном случае — значение false.

Примеры

В следующем примере кода показано, как сохранить пакет в файловой системе в родительской папке myFolder2. Затем в примере проверяется, был ли пакет сохранен с помощью запроса с помощью ExistsOnDtsServer метода.

static void Main(string[] args)  
        {  
            // The variable pkg points to the location  
            // of the ExecuteProcess package sample   
            // that is installed with the SSIS samples.  
            string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";  

            Application app = new Application();  
            Package p = app.LoadPackage(pkg, null);  

            // Save the package under myFolder which is found under the   
            // File System folder on the DTS Service  
            app.SaveToDtsServer(p, null, @"File System\myFolder2", "yourserver");  

            // Verify that the package was saved by   
            // using ExistsOnDtsServer.  
            Boolean packageExists = app.ExistsOnDtsServer(@"File System\myFolder", "yourserver");  
            Console.WriteLine("Package exists? " + packageExists);  
        }  

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 pkg 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()   
            Dim p As Package =  app.LoadPackage(pkg,Nothing)   

            ' Save the package under myFolder which is found under the   
            ' File System folder on the DTS Service  
            app.SaveToDtsServer(p, Nothing, "File System\myFolder2", "yourserver")  

            ' Verify that the package was saved by   
            ' using ExistsOnDtsServer.  
            Dim packageExists As Boolean =  app.ExistsOnDtsServer("File System\myFolder", "yourserver")   
            Console.WriteLine("Package exists? " + packageExists)  
End Sub  

Образец вывода:

Folder exists? True

Package exists? True

Folder exists? False