Lookup value from a table based on a column value in an SSIS Flat File Source

I have a CSV file which I read into SSIS using Flat File Source. This CSV doesn't have all the columns required by the destination - I need to get the row values for these columns from other tables based on the row values in the CSV.

I thought you could enter a SELECT statement such as "select id from testtable where testcode = ?" in the expression field in the Derived Column component but this will not parse.

Does anyone know how to do this in SSIS?
meningaAsked:
Who is Participating?
 
i2mentalConnect With a Mentor Commented:
It sounds like you just need to do a lookup transformation. You'll need a connection manager pointed to that testtable obviously. Just add the lookup to your data flow and create the join to the testtable on testcode. Add the value you're looking up from the test table as a new column and you're done.

Derived columns use expressions.
0
 
chapmandewCommented:
You'll likely need to use the Lookup tasks in SSIS to do this.
0
 
chapmandewCommented:
Why are you closing this?  
0
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.