Hi Henrik

I have tried the new CRLF parameter in the SQL Query - have tried 'pipe' for both the delimiter and the Linebreak but it doesn't seem to be 'breaking' the fields at the Pipe in STDOUT.

Is there something else I need to set?

Cheers

Andy

When we tested this we took your output and ran through the Loop (with pipe as new line). Are you saying that output does not work but hard code does?

---

Hi Henrik

Just to be sure we are talking about the same thing here....

In my SQL Task I have a select query. In the output task of the SQL I have specified both Field Separator and Line Break as Pipe (see screenshot sql pipe). But when I run the job the stdout from the query is still a single record (see screenshot sqlstdout).

You are mentioning the Loop. where should I be specifying the line break for this?

Perhaps I misunderstood you but you wrote before that you already had this output:

1|1|01/02/2012 13:37:48|28/02/2012 14:07:34|1|JTINVPDF.PRF|v|info@mavensystems.co.uk|1|na|na

And then we added support for looping through the result in the Loop.

We have not altered anything in the SQL Query output. Just loop functionality as we thought you wanted to loop through and existing output.

---

Hi Henrik

Ahhhh - I see . I hadn't realised you had done this in the Looping! I thought it was in the SQL Output dialogue as that has changed in 6.08.

Putting it in the loop is even better!!! Thank you

Just going to test it now!

Cheers

Andy