• 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)