you can either use Script task in Data Transformation or use T-SQL.

If using T-Sql, load data into temp table with BULK INSERT (all data in one column), then transfer data...