I was able to get this working by doing a data conversion prior to the oledb destination. And then storing the data conversion column in the table. I don't understand though why I can't do the data conversion after the oledb destination.