You could still use UPPER or LOWER (or their equivalent in SSIS Expression) to compare.

What you'd need to do is alter the mapping in the package by looking to see if the case insensitive comparison was valid, then take the new value from the database and use that in the mapping.

It's a mess, for sure. I don't know if SSIS can compare mapping fields in a CI manner.