Get Column Name/Value pairs from a script component SSIS.

I have an SSIS 'Script Component' which takes a number of input columns from the SSIS pipeline. Within the script component I have the following default code (see code). What I need is a way to iterate through all of the columns in the Input0Buffer and process them individually. This is a task that is going to be used in many different places with a number of different input columns so the solution needs to be generic. Any ideas?

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

End Sub

Open in new window

Who is Participating?
check out this port

few ways to  iterate through all of the columns in the Input0Buffer
Blowfelt82Author Commented:
Did the job, thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.