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?