Condividi tramite


Application.ExistsOnSqlServer(String, String, String, String) Metodo

Definizione

Restituisce un valore booleano che indica se il pacchetto specificato esiste nell'istanza di 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

Parametri

packagePath
String

Pacchetto desiderato.

serverName
String

Nome dell'istanza di SQL Server in cui cercare il pacchetto.

serverUserName
String

Nome utente da autenticare nell'istanza di SQL Server.

serverPassword
String

Password per l'account serverUserName specificato.

Restituisce

true se il pacchetto esiste nell'istanza specificata di SQL Server. false se il pacchetto non esiste.

Esempio

L'esempio di codice seguente crea una cartella SQL Server, verifica che esista e quindi rimuove la cartella e ricontrolla l'esistenza. Salva anche un pacchetto e verifica che il pacchetto sia stato salvato usando il ExistsOnSqlServer metodo .

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  

Esempio di output

Folder exists? True

Package exists? True

Folder exists? False

Si applica a