<div>
You'll likely need to use the Lookup tasks in SSIS to do this.
</div>


<div>
Why are you closing this? &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
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. <br />
<br />
I thought you could enter a SELECT statement such as &quot;select id from testtable where testcode = ?&quot; in the expression field in the Derived Column component but this will not parse.<br />
<br />
Does anyone know how to do this in SSIS?
</div>
</div>


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?

You&#39;ll likely need to use the Lookup tasks in SSIS to do this.

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&#39;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 &quot;select id from testtable where testcode = ?&quot; in the expression field in the Derived Column component but this will not parse.

Does anyone know how to do this in SSIS?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.