Hi the below steps might help to solve issue more quickly.
1.Use the OLE DB Destination.
2.Use the "Table or View - fast load " as data access mode.
3.Check “Keep nulls” and “Table lock” property, and keep the other properties unchecked.
4.Map the new converted columns to SQL destination table columns.
Thanks,
Hemanth(CTS)