April 20, 2010 at 5:18 pm
Hi,
I installed Konesans checksum 2008 component on SQL Server 2005 box. It installed successfully but I am not seeing the component in 2005 BIDS toolbox and when I am trying to add it in I am getting error "Could not load file or assembly 'Microsoft.SqlServer.PipelineHost, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the file specified.'
Can anyone help me out in fixing the issue.
Thank you
Srini:-)
April 21, 2010 at 10:28 am
srinivasable (4/20/2010)
Hi,I installed Konesans checksum 2008 component on SQL Server 2005 box. It installed successfully but I am not seeing the component in 2005 BIDS toolbox and when I am trying to add it in I am getting error "Could not load file or assembly 'Microsoft.SqlServer.PipelineHost, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the file specified.'
Can anyone help me out in fixing the issue.
Thank you
Srini
You have to install the version for SQL 2005.
April 21, 2010 at 11:11 am
:-)Thanks for the reply,
I want to use Konesans checksum 2008 component in 2005 SSIS packages.
Please let me know to how to add it BIDS tool box.
Thanks in Advance.
Thank you
Srini
April 21, 2010 at 12:06 pm
srinivasable (4/21/2010)
:-)Thanks for the reply,I want to use Konesans checksum 2008 component in 2005 SSIS packages.
Please let me know to how to add it BIDS tool box.
Thanks in Advance.
Thank you
Srini
Srini,
The 2008 component is for 2008 SSIS packages. Why do you expect you can use 2008 version in 2005 packages?
April 21, 2010 at 3:04 pm
Hi,
We have 2 clients. one client is using SQL2008 and the other client is using SQL2005.
I want use 1 set of packages (2005 SSIS packages with Konesans 2008 component).
Thank you
Srini
April 21, 2010 at 3:14 pm
srinivasable (4/21/2010)
Hi,We have 2 clients. one client is using SQL2008 and the other client is using SQL2005.
I want use 1 set of packages (2005 SSIS packages with Konesans 2008 component).
Thank you
Srini
Srini,
There is no way you can use one and same package for both 2005 and 2008. What you can do is implement your package in 2005 and then whenever you have to make changes, make them in the 2005 version. Then use 'Add Existing Package..." command in 2008 solution and the SSIS framework will hopefully upgrade the package without issues to 2008. However for this to work your machine has to have both:
- SQL 2005 and 2008 installed
- Konesans component for 2005 an 2008 installed
April 21, 2010 at 3:36 pm
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
April 21, 2010 at 3:45 pm
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.
April 21, 2010 at 5:29 pm
Thanks for the detailed answer.
We have a package which will save all my packages in msdb databases.
Please let me know if run the packages it's going to upgrade and save it in sql 2008 with konesans 2008 right?
Thank you
Srini
April 21, 2010 at 6:52 pm
srinivasable (4/21/2010)
Thanks for the detailed answer.We have a package which will save all my packages in msdb databases.
Please let me know if run the packages it's going to upgrade and save it in sql 2008 with konesans 2008 right?
Thank you
Srini
Srini,
I'm not sure. You have to try.
April 22, 2010 at 10:51 am
Hi,
I am deploying SQL 2005 packages in SQL 2008 MSDB database by default those packages will be upgraded to 2008. In my case those are not upgrading to 2008 ssis packages.
How can I upgrade SQL 2005 packages without opening in 2008 BIDS.
Is there any command to upgrade the packages?
Thank you
Srini
April 22, 2010 at 10:59 am
srinivasable (4/22/2010)
Hi,I am deploying SQL 2005 packages in SQL 2008 MSDB database by default those packages will be upgraded to 2008. In my case those are not upgrading to 2008 ssis packages.
How can I upgrade SQL 2005 packages without opening in 2008 BIDS.
Is there any command to upgrade the packages?
Thank you
Srini
No, you cannot do this.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply