SSIS Package using a look up

Question

Hi All ,

 

I have to create a SSIS Package that reads data from a CSV file , loads some column values into a table (X) The rest of the columns in table X are to be filled from another table .

 

I have two common columns in both tables .. description and code . Based on the Descrption and code , The rest of the columns are filled in the table .

 

I hope I am clear .

 

Thanks ,