Hints for upgrading from SSIS 2005 to 2008 - Table Difference control

[Shannon]

I recently attempted to upgrade SSIS packages containing a really old
TableDifference control (from sqlBI days). The techical support at
CozyRoc was outstanding and I just wanted to mention briefly what
worked.

Originally, the error(s) I received were:
Error 0xc00490f7: MyTaskName: The managed pipeline component
"SqlBi.SSIS.Components.TableDifference, TableDifference,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=729551dd7e47caaf"
could not be loaded. The exception was: Could not load file or
assembly 'Microsoft.SqlServer.PipelineHost, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its
dependencies. The system cannot find the file specified..

Error 0xc0047067: MyTaskName: The "component "TableDifference" (505)"
failed to cache the component metadata object and returned error code
0x80131600.

Error 0xc004706c: MyTaskName: Component "component
"TableDifference" (505)" could not be created and returned error code
0xC0047067. Make sure that the component is registered correctly.

Error 0xc0048021: MyTaskName: The component is missing, not
registered, not upgradeable, or missing required interfaces. The
contact information for this component is "".

Error 0xc004801f: MyTaskName: The component metadata for "component
"TableDifference" (505)" could not be upgraded to the newer version of
the component. The PerformUpgrade method failed.

Before you try any of the following, make sure to backup your package
or commit to code control!

Steps to resolve:
1. Install SQL Server 2005 with SSIS BIDS (Business Intelligence
Development Studio) on same environment as SQL Server 2008 with BIDs.
This ensured we had all libraries from 2005 and 2008.
2. Install original TableDifference component - make sure to test it
out in a dummy solution/package.
3. Install latest TableDifference component for 2005 and newer for
2008 - make sure to test it out in a dummy solution/package.
4. In SSIS BIDS 2005, add old and new 2005 TableDifference to a
package dataflow - name them so you can tell them apart.
5. View the XML code for a package you want to fix.
6. Find your old Table Difference's component tag and replace
everything after the name attribute with the code from the newer 2005
TableDifference component tag.
7. Do the same as the previous step for the old Table Difference's
property tag that has the name attribute of
'UserComponentTypeName' ... replace everything after the name
attribute with the newer 2005 Table Difference's property attributes.
Take care not to break the XML!
8. Save and verify you can now view the designer and no new errors
appear.
9. Close the solution and open SSIS 2008 BIDS. Open a dummy solution
and Open your 2005 solution and the upgrade wizard should appear.
Complete the upgrade.
10. When you are finished upgrading you should be able to see your
Table Difference component appear correctly in your packages.

Hope that helps!

--
You received this message because you are subscribed to the Google Groups "CozyRoc" group.
To post to this group, send email to coz...@googlegroups.com.
To unsubscribe from this group, send email to cozyroc+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/cozyroc?hl=en.