srinivasable (4/21/2010)
I did that way too but when I am upgrading the packages are failing because of Konesans. by default konesans are not upgrading to 2008 konesans.Thank you
Srini
Srini,
You have to contact Konesans people and ask them to include the so-called upgrade manifest. It is very simple document, used by the SSIS framework to map the old component version to the new. You may also try to define the manifest by yourself. For example the Trash Destination manifest looks like this:
<?xml version="1.0" ?>
<Mappings xmlns="http://www.microsoft.com/SqlServer/Dts/UpgradeMapping.xsd">
<!--
Konesans SQL Server Integration Services Upgrade Mappings
Copyright © 2008 Konesans Limited
%ProgramFiles%\Microsoft SQL Server\100\DTS\UpgradeMappings
Upgrade mapping for SQL Server 2005 to SQL Server 2008.
-->
<ExtensionMapping
tag="Konesans Trash Destination"
oldAssemblyStrongName="Konesans.Dts.Pipeline.TrashDestination.Trash, Konesans.Dts.Pipeline.TrashDestination, Version=1.0.1.0, Culture=neutral, PublicKeyToken=b8351fe7752642cc"
newAssemblyStrongName="Konesans.Dts.Pipeline.TrashDestination.Trash, Konesans.Dts.Pipeline.TrashDestination, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992b"
/>
</Mappings>
The manifest has to be deployed in this folder:
\Microsoft SQL Server\100\DTS\UpgradeMappings
and the file must have .xml extension.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
