Application.SaveToDtsServer(Package, IDTSEvents, String, String) Метод

  • Ссылка

Определение

Пространство имен:
Microsoft.SqlServer.Dts.Runtime
Сборка:
Microsoft.SqlServer.ManagedDTS.dll

Сохраняет пакет в файловой системе.

public:
 void SaveToDtsServer(Microsoft::SqlServer::Dts::Runtime::Package ^ pPackage, Microsoft::SqlServer::Dts::Runtime::IDTSEvents ^ pEvents, System::String ^ sPackagePath, System::String ^ sServerName);
public void SaveToDtsServer (Microsoft.SqlServer.Dts.Runtime.Package pPackage, Microsoft.SqlServer.Dts.Runtime.IDTSEvents pEvents, string sPackagePath, string sServerName);
member this.SaveToDtsServer : Microsoft.SqlServer.Dts.Runtime.Package * Microsoft.SqlServer.Dts.Runtime.IDTSEvents * string * string -> unit
Public Sub SaveToDtsServer (pPackage As Package, pEvents As IDTSEvents, sPackagePath As String, sServerName As String)

Параметры

pPackage
Package

Пакет, который необходимо сохранить.

pEvents
IDTSEvents

Объект IDTSEvents.

sPackagePath
String

Имя, которое должно быть присвоено пакету при сохранении. Можно указать имя с префиксом в виде обозначения пути. Например, чтобы сохранить пакет с именем «myPackage» в папке «File System», нужно указать параметр @"File System\myPackage".

sServerName
String

Имя сервера, на котором должен быть сохранен пакет.

Примеры

В следующем примере кода показано, как сохранить пакет в папку файловой системы с именем myFolder2. Затем в примере проверяется, был ли пакет сохранен путем вызова ExistsOnDtsServer метода.

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 under myFolder which is found under the   
            // File System folder on the Integration Services service.  
            app.SaveToDtsServer(p, null, @"File System\myFolder2", "yourserver");  

            // Verify that the package was saved by calling ExistsOnDtsServer.  
            Boolean packageExists = app.ExistsOnDtsServer(@"File System\myFolder2", "yourserver");  
            Console.WriteLine("Package exists? " + packageExists);  
        }  

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 under myFolder which is found under the   
    ' File System folder on the Integration Services service.  
    app.SaveToDtsServer(p, Nothing, "File System\myFolder2", "yourserver")  

    ' Verify that the package was saved by calling ExistsOnDtsServer.  
    Dim packageExists As Boolean =  app.ExistsOnDtsServer("File System\myFolder2","yourserver")   
    Console.WriteLine("Package exists? " + packageExists)  
End Sub

Образец вывода:

Package exists? True

Применяется к