I think you'll want to use the SSIS Lookup Transformation. There are many ways yo configure it to suit your scenario. Most considerations surround the number of records in the incoming file and the number of rows in the lookup table. Post here, or post a new topic if you have more questions related to setting it up.