Application.SaveToSqlServer Yöntemi
paket örnek olarak kaydeder SQL Server.
Ad Alanı: Microsoft.SqlServer.Dts.Runtime
Derleme: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS içinde.dll)
Sözdizimi
'Bildirim
Public Sub SaveToSqlServer ( _
package As Package, _
events As IDTSEvents, _
serverName As String, _
serverUserName As String, _
serverPassword As String _
)
'Kullanım
Dim instance As Application
Dim package As Package
Dim events As IDTSEvents
Dim serverName As String
Dim serverUserName As String
Dim serverPassword As String
instance.SaveToSqlServer(package, events, _
serverName, serverUserName, serverPassword)
public void SaveToSqlServer(
Package package,
IDTSEvents events,
string serverName,
string serverUserName,
string serverPassword
)
public:
void SaveToSqlServer(
Package^ package,
IDTSEvents^ events,
String^ serverName,
String^ serverUserName,
String^ serverPassword
)
member SaveToSqlServer :
package:Package *
events:IDTSEvents *
serverName:string *
serverUserName:string *
serverPassword:string -> unit
public function SaveToSqlServer(
package : Package,
events : IDTSEvents,
serverName : String,
serverUserName : String,
serverPassword : String
)
Parametreler
- package
Tür: Microsoft.SqlServer.Dts.Runtime.Package
Kaydetmek için paket.
- events
Tür: Microsoft.SqlServer.Dts.Runtime.IDTSEvents
IDTSEvents Nesne.
- serverName
Tür: System.String
örnek adı SQL Server kaydetmek için paket için.
- serverUserName
Tür: System.String
SQL Server Oturum açma adı kullanırsanız SQL Server ; sunucuya oturum açmak için kimlik doğrulama Aksi takdirde, nullnull başvuru (Visual Basic'te Nothing) , Windows kimlik doğrulaması kullanıyorsanız.
- serverPassword
Tür: System.String
SQL Server Oturum açma parolası kullanırsanız SQL Server ; sunucuda oturum kimlik doğrulaması Aksi takdirde, nullnull başvuru (Visual Basic'te Nothing) , Windows kimlik doğrulaması kullanıyorsanız.
Örnekler
Aşağıdaki kod örneği, dosya sistemi altında örnek paket kaydeder.paket kaydedilmiş doğrulamak için aşağıdaki Transact-sql sorgusu çalıştırın msdb veritabanı.Sorgu döndürür depolanan tüm paketleri msdb Sistem tablo.
select * from sysssispackages
Veya bağlanmak Integration Services hizmet, genişletme Depolanan paketlerive sonra msdb.paket DTSPackage1 adı ile listelenir.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LoadFromSQLServerTest
{
class Program
{
static void Main(string[] args)
{
// The variable, pkg, points to the location
// of the UsingExecuteProcess sample installed with
// the SSIS package 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 loadedPkg = app.LoadPackage(pkg, null);
// Save the package to SQL Server.
app.SaveToSqlServer(loadedPkg, null, "yourserver", null, null);
// The package can now be viewed in the
// Microsoft SQL Server Management Studio, in the
// Integration Services / Stored Packages / MSDB folder,
// with the name UsingExecuteProcess.
Package pkgIn = new Package();
pkgIn = app.LoadFromSqlServer("\\UsingExecuteProcess", "yourserver", null, null, null);
DateTime pkgCreation = pkgIn.CreationDate;
Console.WriteLine("Creation Date = {0}", pkgCreation);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LoadFromSQLServerTest
Class Program
Shared Sub Main(ByVal args() As String)
' The variable, pkg, points to the location
' of the UsingExecuteProcess sample installed with
' the SSIS package 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 loadedPkg As Package = app.LoadPackage(pkg,Nothing)
' Save the package to SQL Server.
app.SaveToSqlServer(loadedPkg, Nothing, "yourserver", Nothing, Nothing)
' The package can now be viewed in the
' Microsoft SQL Server Management Studio, in the
' Integration Services / Stored Packages / MSDB folder,
' with the name UsingExecuteProcess.
Dim pkgIn As Package = New Package()
pkgIn = app.LoadFromSqlServer("\\UsingExecuteProcess", "yourserver", Nothing, Nothing, Nothing)
Dim pkgCreation As DateTime = pkgIn.CreationDate
Console.WriteLine("Creation Date = {0}", pkgCreation)
End Sub
End Class
End Namespace
Örnek Çıktı:
Creation Date = 5/5/2003 5:46:00 PM