Write File Transformation

[closesupport]

I need to use the Write File Transformation to write multiple rows to a series of files. The filenames need to come from data so it looked like this type of transformation would be good. Test data looks like:

rowdata destinationfile
======= ===============
row1 file1.txt
row2 file1.txt
row3 file1.txt
row4 file2.txt
row4 file2.txt
row5 file1.txt

The transformation is set to append the data to the files.

The result is that the row data appears on one line in the output files. I need each row to appear as a separate line.

Am I heading in the right direction? How can I achieve multiple rows in the files?

TIA

Pete

 

[closesupport]

I think I may have answered this myself! I appended each data row with

+ CHAR(10 + CHAR(13)

and that did the trick. There may wel be a more elegant solution??