Hello
Trying to figure out a clever solution for splitting multivalued columns out
into n-columns.
For that I've build a custom component in SSIS using
ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/dtsref9/html/4dc0f631-8fd6-4007-b573-ca67f58ca068.htm as an example.

I need to be able to add columns to the OutputCollection in designtime, but
the designer returns an error:
Error at Data Flow Task [Uppercase [5910]]: The component "Uppercase" (5910)
does not allow setting output column datatype properties.

How do I enable the designer to accept designtime changes in the
columncollection?

Kind regards

Hello Janus,

You can add columns to the OutputColumnCollection. I can see nothing initially
that would stop you splitting a column

You can do the splitting though like this

http://www.sqlis.com/default.aspx?307


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thank you, it brings me a bit further :-)




"Allan Mitchell" wrote: