Have you seent DataConversion task in SSIS pipes, as this seems to be what you are looking for. simply place it after the extractor, and do the conversion on the column, then run that into the Lookup and join on your new converted column.