Application.Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents)
Application.Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents)
Application.Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents)
Application.Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents)
Method
Definition
Upgrades one or more Integration Services packages from a specified source location to a specified destination location.
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
Parameters
- packages
- IEnumerable<UpgradePackageInfo>
The collection of packages to be upgraded.
An StorageInfo object that specifies the source location for the packages to be upgraded.
- destination
- StorageInfo StorageInfo StorageInfo StorageInfo
The StorageInfo object that specifies the destination location for the packages to be upgraded.
A BatchUpgradeOptions object that specifies the options that will be applied to the packages during the upgrade process.
- events
- IDTSEvents IDTSEvents IDTSEvents IDTSEvents
An IDTSEvents object.
Returns
An UpgradeResult object that specifies the result of upgrading one or more packages.
Examples
The following example shows how to upgrade a collection of packages. The original packages and the upgrade packages are stored in a folder in the file system.
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();
}
}
}