Application.Upgrade Método

Definição

Atualiza um ou mais pacotes do Integration Services de um local de origem para um local de destino especificados.

public:
 Microsoft::SqlServer::Dts::Runtime::UpgradeResult ^ Upgrade(System::Collections::Generic::IEnumerable<Microsoft::SqlServer::Dts::Runtime::UpgradePackageInfo ^> ^ packages, Microsoft::SqlServer::Dts::Runtime::StorageInfo ^ source, Microsoft::SqlServer::Dts::Runtime::StorageInfo ^ destination, Microsoft::SqlServer::Dts::Runtime::BatchUpgradeOptions ^ options, Microsoft::SqlServer::Dts::Runtime::IDTSEvents ^ events);
public Microsoft.SqlServer.Dts.Runtime.UpgradeResult Upgrade (System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Dts.Runtime.UpgradePackageInfo> packages, Microsoft.SqlServer.Dts.Runtime.StorageInfo source, Microsoft.SqlServer.Dts.Runtime.StorageInfo destination, Microsoft.SqlServer.Dts.Runtime.BatchUpgradeOptions options, Microsoft.SqlServer.Dts.Runtime.IDTSEvents events);
member this.Upgrade : seq<Microsoft.SqlServer.Dts.Runtime.UpgradePackageInfo> * Microsoft.SqlServer.Dts.Runtime.StorageInfo * Microsoft.SqlServer.Dts.Runtime.StorageInfo * Microsoft.SqlServer.Dts.Runtime.BatchUpgradeOptions * Microsoft.SqlServer.Dts.Runtime.IDTSEvents -> Microsoft.SqlServer.Dts.Runtime.UpgradeResult
Public Function Upgrade (packages As IEnumerable(Of UpgradePackageInfo), source As StorageInfo, destination As StorageInfo, options As BatchUpgradeOptions, events As IDTSEvents) As UpgradeResult

Parâmetros

packages
IEnumerable<UpgradePackageInfo>

A coleção de pacotes a ser atualizada.

source
StorageInfo

Um objeto StorageInfo que especifica o local de origem para os pacotes a serem atualizados.

destination
StorageInfo

O objeto StorageInfo que especifica o local de destino para os pacotes a serem atualizados.

options
BatchUpgradeOptions

Um objeto BatchUpgradeOptions que especifica as opções que serão aplicadas aos pacotes durante o processo de atualização.

events
IDTSEvents

Um objeto IDTSEvents.

Retornos

Um objeto UpgradeResult que especifica o resultado da atualização de um ou mais pacotes.

Exemplos

O exemplo a seguir mostra como atualizar uma coleção de pacotes. Os pacotes originais e os pacotes de atualização são armazenados em uma pasta no sistema de arquivos.

using System;  
using System.Collections.Generic;  
using System.Collections.ObjectModel;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace ConsoleApplication1  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  

            Application app = new Application();  

            UpgradePackageInfo packinfo1 = new UpgradePackageInfo("C:\\temp\\Package.dtsx", "C:\\temp\\Package.dtsx", null);  
            UpgradePackageInfo packinfo2 = new UpgradePackageInfo("C:\\temp\\Package2.dtsx", "C:\\temp\\Package2.dtsx", null);  

            Collection<UpgradePackageInfo> packages = new Collection<UpgradePackageInfo>();  
            packages.Add(packinfo1);  
            packages.Add(packinfo2);  

            StorageInfo storeinfoSource = StorageInfo.NewFileStorage();  
            storeinfoSource.RootFolder = "C:\\temp";  

            StorageInfo storeinfoDest = StorageInfo.NewFileStorage();  
            BatchUpgradeOptions upgradeOpts = new BatchUpgradeOptions();  
            upgradeOpts.Validate = true;  
            upgradeOpts.BackupOldPackages = true;  
            upgradeOpts.ContinueOnError = true;  
            upgradeOpts.ValidationFailureAsError = true;          

            MyEventsClass eventsClass = new MyEventsClass();  

            app.Upgrade(packages, storeinfoSource, storeinfoDest, upgradeOpts, eventsClass);  

        }  
    }  

    class MyEventsClass : DefaultEvents  
    {  
        public override void OnPreExecute(Executable exec, ref bool fireAgain)  
        {  
            Console.WriteLine("The PreExecute event of the " + exec.ToString() + " has been raised.");  
            Console.Read();  
        }  
    }  
}  

Aplica-se a