Robert,

The source is an OLD DB connection that is running the below sql statement

select [Entry No_]

, ID

, [User ID]

, [Start Date_Time]

, [End Date_Time]

, Status

, ';' AS Delimeter

from dbo.[Live$Job Queue Log Entry]

where [Start Date_Time] > (GETDATE()-1);

Also see the attached data flow objects.

I tried adding a column as the delimeter hoping ssis would see it and recognize it but the output file is still on one line.

Would it be helpful if I used vim or notepad++ to look at the results?