Microsoft SQL Server advanced settings

You can use the following advanced settings to fine tune sources.

Parameter Default value Description
  • Filename pattern
* A mask/filter to categorize files into this file class. You can select * (many chars) ? (one char), # (a number), or a regex.
  • SQL_fldList
Date,Time,Source,Message:Last=TakeRest The CSV fields to include in the payload. Use #FIELDS to grab first line in the file that starts with #Fields. Use #HDL_LINES to grab list of fields from file header.
  • SQL_fldListSep
  The field list separator handles \t, XML, KEYED (CSV), or NCSA.