It would be useful if you would supply us some sample data for the .dat file.
But as Luis suggested, a flat file destination will probably do the trick.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP