SSIS: merging sql data with script transformation output - which tool?

I have a script transformation that is creating a dataset and I want to do lookup to other sql tables to pull in foreign keys to insert into another table. Do I use a Lookup or something else? Anyone have any links to examples I could follow?
Who is Participating?
Reza RadConnect With a Mentor Consultant, TrainerCommented:
connect output of script component to a lookup transformation and set lookup table ( it must be an OLE DB Connection ) now you have match rows and non match rows output
wppiexpertsAuthor Commented:
what if I have up to 3 tables I want to bring in foreign keys I need a seperate Lookup for each?
Reza RadConsultant, TrainerCommented:
if your input is 3 table, but your lookup table is one,
just merge all inputs with UNION ALL Transformation and then connect output of union all to lookup.
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.