MINUMUM IMPORTER VERSION: 3.21.0000.0000

EVENT: FolderBeforeImport

SYNOPSIS: Calls customizable SQL server query and all saves results as CSV file for import.

DESCRIPTION: SQL to CSV is designed to call SQL server for data. The SQL statement is customizable and all column names that are returned are used as column headers and all the data is written out as one row to one CSV record.

CONFIGURATION: You need to specify the SQL connection string to use and the SQL command to call. You can specify the CSV filename but it is not required. If nothing is specified the SQLOut.csv is used. 

Connection string: The connection string used to connect to the SQL server. This can use any Microsoft standard SQL connection string format.

SQL Command: This is the actual SQL statement to execute to return data. 

CSV File Name: This is the name only of the CSV file to create with the returned data. This file is overwritten each time it is called!