Data Conversion task is a Syncronous transform, it shouldn't be taking 3hrs for 5,000 records. Please post screen shot of your package.

Alternatively, you can use T-SQL to conver the data Select cast (column 1 as datatype) as Column from Table