The source is an OLD DB connection that is running the below sql statement
select [Entry No_]
, [User ID]
, [Start Date_Time]
, [End Date_Time]
, ';' 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?