SSIS: How to Concatenate input columns dynamically in Script Component by using C#
Posted on 2010-08-29
I am trying to dynamically read columns and its data type, and concatenate values by using C#. And it should generate a string of concatenate value which is delaminated by ';'.
I can't use the following from the Script Component " outputbuffer = col1 + col2" because I want to use this function in many other packages and inputs for different pacakages will be different from each other.
Here is an example of what I am trying to do.
Col1 Col2 Col3
123 abc 2kie
456 dic 0ke
I can't use derived column function becuase my output data type is varchar(8000) and derived column can output max of 4000 characters.
Does anyone know how to accomplish this in SSIS? It doen't have to be in Script Component.