[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2806
  • Last Modified:

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

0
Blowfelt82
Asked:
Blowfelt82
1 Solution
 
AmmarRCommented:
check out this port

http://www.sqldev.org/sql-server-integration-services/ssis-script-transformation-loop-through-columns-in-a-row-9668.shtml

few ways to  iterate through all of the columns in the Input0Buffer
0
 
radcaesarCommented:
0
 
Blowfelt82Author Commented:
Did the job, thanks!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now