Katmai - Custom components and upgrade

Steve Walker

sundanceca — Fri, 17 Aug 2007 01:12:12 GMT

We have a custom SSIS pipeline component we developed to access WCF web services and import data. This was written for Sql 2005 and visual studio 2005.

I have quite a few packages using this component, with many tasks, components, etc. downstream from the component in the packages.

I'd like to know if it's possible to upgrade the component that is already in the package without deleting the old one from the toolbox, re-adding the new one, then adding the new component to the existing package, deleting the link from the all the downstream package stuff... It's quite a bit of work to reestablish all the meta data in the package after I upgrade the component. I looked at the source code (xml) for the package and couldn't find anything useful to change (to help). I did re-gac after the upgrade and VS did no "automagically" recognize the new upgraded component.

pain, suffering......

any ideas?

re: Katmai - Custom components and upgrade

mmasson — Fri, 17 Aug 2007 01:30:13 GMT

If you don't change the version number / assembly name of the component, it should be picked up automatically without any changes.

If the version/GUID/ProgID have changed, you should be able to manually edit the package XML. Look for the <component> entry for your component. For managed components, look for the UserComponentTypeName attribute - this should be the strong assembly name for your class. As long as your metadata hasn't changed, changing this to the new value should fix your problem.

Custom Extensions in SQL Server 2008

SSIS Stuff — Sat, 02 Feb 2008 00:57:27 GMT

The introduction of new SSIS features in the SQL Server 2008 release and beyond made it necessary for

Custom Extensions in SQL Server 2008

Noticias externas — Sat, 02 Feb 2008 01:10:45 GMT

The introduction of new SSIS features in the SQL Server 2008 release and beyond made it necessary for

Custom Extensions in SQL Server 2008

aspnetkkk123 — Sun, 16 Mar 2008 17:55:14 GMT

Custom Extensions in SQL Server 2008

Upgrading Custom Components for SQL Server 2008 Integration Services

Douglas Laudenschlager — Wed, 11 Jun 2008 17:57:48 GMT

The SQL Server 2008 Books Online page in which we describe the steps for upgrading and redistributing

re: Katmai - Custom components and upgrade

jamiet — Sat, 07 Nov 2009 14:22:52 GMT

Hiya Matt,

I'm converting a v2005 component and its got a call to the following method:

IDTSOutputColumn100.SetDataTypeProperties.

In the code I've inherited the first parameter is an integer however now the method is expecting something from the DataType enum.

THis is easy to fix but nonetheless, do you know of any other gotchas like this?

cheers

Jamie

re: Katmai - Custom components and upgrade

jamiet — Sat, 07 Nov 2009 16:52:35 GMT

Ignore the previous comment!! The code I'm changing was generated form Reflector - hence there's an integer where an enum is expected!

sorry!