One of the workarounds is to read an entire line is as a single row, then use the Script Component and write your own logic to break it apart and output.

Vote on it over at Microsoft Conect, maybe they'll fix it; It's still broken in SSIS in SQL 2008.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=312164