Application.ExistsOnDtsServer(String, String) Método

Definição

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Retorna um booliano que indica se o pacote especificado já existe no serviço 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

Parâmetros

sPackagePath

String

O caminho totalmente qualificado do pacote.

sServerName

String

O nome do servidor para pesquisar o pacote.

Retornos

Boolean

true se o pacote especificado por sPackagePath existir no servidor nomeado por sServerName; caso contrário, false.

Exemplos

O exemplo de código a seguir mostra um pacote sendo salvo no Sistema de Arquivos na pasta pai. myFolder2 O exemplo verifica se o pacote foi salvo consultando usando o ExistsOnDtsServer método.

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  

Saída de exemplo:

Folder exists? True

Package exists? True

Folder exists? False