SSIS Lookup transformation help

Question

Good Day,

I am new to SSIS, could please suggest me about Lookup transformation.

Ex: I would like to see my data after lookup in the database side

      Person ID     Course

       1               SharePoint

       2               SSIS

       3               SSRS

but, i am getting like this,

       Person ID     Course

       1              

       2              

       3              

      NULL             SharePoint

      NULL              SSIS

      NULL              SSRS

could please provide me suitable solution, thank you.

Kind Regards

               

                                     

Answer 1

If you are performing lookup based on Cource check whether all casing of charecters are propoer, because lookup task operations are case sensitive. Even if you compare sharePoint instead SharePoint it will considered as Unmatched records.

For more detail on lookup transformation check the below link.

http://msdn.microsoft.com/en-us/library/ms141821.aspx

https://www.simple-talk.com/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/

Regards

Naveen

Answer 2

I would Like to Add to Naveen's post...

Always Use "TRIM(UPPER(" on the source column and lookup column before using lookup so that you do not land up in situations like you stated above.