Application.ExistsOnSqlServer(String, String, String, String) Método

Referência

Definição

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Importante

Algumas informações se referem a produtos de pré-lançamento que podem ser substancialmente modificados antes do lançamento. A Microsoft não oferece garantias, expressas ou implícitas, das informações aqui fornecidas.

Retorna um Boolean que indica se o pacote especificado existe na instância de SQL Server.

public:
 bool ExistsOnSqlServer(System::String ^ packagePath, System::String ^ serverName, System::String ^ serverUserName, System::String ^ serverPassword);

public bool ExistsOnSqlServer (string packagePath, string serverName, string serverUserName, string serverPassword);

member this.ExistsOnSqlServer : string * string * string * string -> bool

Public Function ExistsOnSqlServer (packagePath As String, serverName As String, serverUserName As String, serverPassword As String) As Boolean

Parâmetros

packagePath: String

O pacote que você está procurando.

serverName: String

O nome da instância do SQL Server para pesquisar o pacote.

serverUserName: String

O nome de usuário para autenticar na instância do SQL Server.

serverPassword: String

A senha do serverUserName especificado.

Retornos

Boolean

true se o pacote existir na instância especificada de SQL Server. false se o pacote não existir.

Exemplos

O exemplo de código a seguir cria uma pasta SQL Server, verifica se ela existe e remove a pasta e verifica novamente sua existência. Ele também salva um pacote e verifica se o pacote foi salvo usando o ExistsOnSqlServer 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 p = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";  

            Application app = new Application();  

            // Create a folder on SQL Server in the msdb database.  
            app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", null, null);  

            // Verify that the folder exists by using ExistsOnSqlServer method.  
            Boolean folderExists = app.FolderExistsOnSqlServer("myNewFolder", "yourserver", null, null);  
            Console.WriteLine("Folder exists? {0}", folderExists);  

            // Load a package and save it.  
            Package pkg = app.LoadPackage(p, null);  
            app.SaveToSqlServerAs(pkg, null, "newPkg", "yourserver", null, null);  

            // Verify that the package was saved.  
            Boolean packageExists = app.ExistsOnSqlServer("newPkg", "yourserver", null, null);  
            Console.WriteLine("Package exists? {0}", packageExists);  

            //Remove the folder.  
            app.RemoveFolderFromSqlServer("myNewFolder", "yourserver", null, null);  

            // Verify that the folder was removed by using the ExistsOnSqlServer method.  
            folderExists = app.FolderExistsOnSqlServer("myNewFolder", "yourserver", null, null);  
            Console.WriteLine("Folder exists? {0}", folderExists);  
        }

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 p 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()   

            ' Create a folder on SQL Server in the msdb database.  
            app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", Nothing, Nothing)  

            ' Verify that the folder exists by using ExistsOnSqlServer method.  
            Dim folderExists As Boolean =  app.FolderExistsOnSqlServer("myNewFolder","yourserver",Nothing,Nothing)   
            Console.WriteLine("Folder exists? {0}", folderExists)  

            ' Load a package and save it.  
            Dim pkg As Package =  app.LoadPackage(p,Nothing)   
            app.SaveToSqlServerAs(pkg, Nothing, "newPkg", "yourserver", Nothing, Nothing)  

            ' Verify that the package was saved.  
            Dim packageExists As Boolean =  app.ExistsOnSqlServer("newPkg","yourserver",Nothing,Nothing)   
            Console.WriteLine("Package exists? {0}", packageExists)  

            'Remove the folder.  
            app.RemoveFolderFromSqlServer("myNewFolder", "yourserver", Nothing, Nothing)  

            ' Verify that the folder was removed by using the ExistsOnSqlServer method.  
            folderExists = app.FolderExistsOnSqlServer("myNewFolder", "yourserver", Nothing, Nothing)  
            Console.WriteLine("Folder exists? {0}", folderExists)  
End Sub

Saída de exemplo:

Folder exists? True

Package exists? True

Folder exists? False

Aplica-se a

Share via