Need guidance on how to write data from Javelin in batch mode from an MS SQL server to an excel spreadsheet.
The reason for this is that when we try to export 60K rows at one time the export fails.
TDM Portal -18.104.22.168
Database - Microsoft SQL Server Developer v12.0.6329.1
Find attached an example flow that shows how you can import data from a SQL server into a DataTable in Javelin and then work through the records in batch mode to write to an excel spreadsheet.
this requires adding the following imports:
This was built and tested on Javelin 4.8.137