โ09-29-2020 03:07 PM
Hi,
I am reading some table data from a SQL Server (โSQL Server - Executeโ snap) and writing the output to a text file (โFile Writerโ snap) (using a โCSV formatterโ between he above snaps)
โSQL Server - Executeโ โ โCSV formatterโ โ โFile Writerโ
Requirement
i.e. If the SQL query returns 99 records, the file should look like
99
Row 1
Row 2
Row 3
โฆ
โฆ
Row 99
Any help on how can I achieve this is appreciated.
Thanks!
Solved! Go to Solution.
โ09-29-2020 11:35 PM
try attached pipeline. rowCountWriteToFile_2020_09_30.slp (13.1 KB)
โ09-29-2020 11:35 PM
try attached pipeline. rowCountWriteToFile_2020_09_30.slp (13.1 KB)
โ09-30-2020 06:28 AM
This is great, met my requirements, thanks for your quick response!