A program that parsez out any column in SQL Server 2017 including the new JSON Columns.
You can configure the following parameters in the app.config:
- Connection String (Intended server)
- SQL Statement
- Final File Path- Where to place the final file
- Command Timeout -In case the sql statement takes a while to run
Allow the deliminator to be changed via the app.config.
This version has been tested with exporting a table from SQL with 43K records and 60 columns for 110MB file size within 30 seconds. It correctly parse valid JSON fields.