Do you use a upper and/or trim before you go to the Lookup transformation?

Ah, it's more easy than it was at first 😉

But I believe he didnt want to script?

Hmmz, my mail to you uses an open the csv in Excel, sort ASC on Column A, save and go.

But to leave the file as is... Hmmm, in SSIS I...

I think you can use a (L)TRIMM function after the import on the columns.

And regarding the skipping of blanc records you could delete the blanc records afterwards.