SSIS Lookup com­po­nent is case sensitive

The other day, i was working on a new SSIS (SQL Server Integration Services) package to transform data from a production database to an analysis database. It worked quite well, i thought, everything seemed to work as it was supposed to when testing with a subset of data. So next up, live usage. And that […]