Application.ExistsOnSqlServer(String, String, String, String) Metode

Referensi

Definisi

Ruang nama:: Microsoft.SqlServer.Dts.Runtime

Rakitan:: Microsoft.SqlServer.ManagedDTS.dll

Penting

Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.

Mengembalikan Boolean yang menunjukkan apakah paket yang ditentukan ada pada instans 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

Parameter

packagePath: String

Paket yang Anda cari.

serverName: String

Nama instans SQL Server untuk mencari paket.

serverUserName: String

Nama pengguna untuk mengautentikasi terhadap instans SQL Server.

serverPassword: String

Kata sandi untuk yang ditentukan serverUserName.

Mengembalikan

Boolean

true jika paket ada pada instans SQL Server yang ditentukan. false jika paket tidak ada.

Contoh

Contoh kode berikut membuat folder SQL Server, memverifikasi bahwa folder tersebut ada, lalu menghapus folder dan mencentang kembali keberadaannya. Ini juga menyimpan paket dan memverifikasi bahwa paket disimpan menggunakan ExistsOnSqlServer metode .

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

Contoh Output:

Folder exists? True

Package exists? True

Folder exists? False

Berlaku untuk

Bagikan melalui