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

истинно, если пакет, заданный , 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