Application.SaveToSqlServerAs Metode

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Menyimpan paket ke instans SQL Server dengan nama baru.

public:
 void SaveToSqlServerAs(Microsoft::SqlServer::Dts::Runtime::Package ^ package, Microsoft::SqlServer::Dts::Runtime::IDTSEvents ^ events, System::String ^ packagePath, System::String ^ serverName, System::String ^ serverUserName, System::String ^ serverPassword);

public void SaveToSqlServerAs (Microsoft.SqlServer.Dts.Runtime.Package package, Microsoft.SqlServer.Dts.Runtime.IDTSEvents events, string packagePath, string serverName, string serverUserName, string serverPassword);

member this.SaveToSqlServerAs : Microsoft.SqlServer.Dts.Runtime.Package * Microsoft.SqlServer.Dts.Runtime.IDTSEvents * string * string * string * string -> unit

Public Sub SaveToSqlServerAs (package As Package, events As IDTSEvents, packagePath As String, serverName As String, serverUserName As String, serverPassword As String)

Parameter

package

Package

Paket untuk disimpan.

events

IDTSEvents

Objek IDTSEvents.

packagePath

String

Jalur dan nama baru untuk ditetapkan ke paket. Parameter packagePath dalam format \folder\packageName. Jika packagePath ditentukan tanpa folder yang ada, paket akan disimpan dengan parameter ini sebagai nama barunya.

serverName

String

Nama instans SQL Server.

serverUserName

String

Nama akun yang digunakan untuk masuk ke instans SQL Server.

serverPassword

String

Kata sandi akun pengguna.

Contoh

Contoh kode berikut menyimpan paket sampel bernama ExecuteProcess.dtsx ke folder msdb , dengan nama baru myNewPackage. Untuk memverifikasi bahwa paket disimpan, jalankan kueri Transact-SQL berikut ini terhadap database msdb . Kueri mengembalikan semua paket yang disimpan dalam tabel sistem msdb .

select * from sysssispackages

Atau, sambungkan ke layanan Layanan Integrasi, perluas Paket Tersimpan, lalu perluas MSDB. Paket dengan nama yang ditentukan di packagePath akan dicantumkan.

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 to the SQL Server msdb folder, which is  
           // also the MSDB folder in the Integration Services service, or as a row in the  
           //sysssispackages table.  
            app.SaveToSqlServerAs(p, null, "myNewPackage", "yourserver", null, null);  
        }  

Shared  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 to the SQL Server msdb folder, which is  
           ' also the MSDB folder in the Integration Services service, or as a row in the  
           'sysssispackages table.  
            app.SaveToSqlServerAs(p, Nothing, "myNewPackage", "yourserver", Nothing, Nothing)  
End Sub