Create text files

In the same way that data sets can be sent from the SQL server to a table og pivot table, it is possible to copy data sets to text files using a "#_F_" prefix. For each text, the filename, column delimiter, handling of NULL-values, character and other parameters can be set get the desired result. 

Overview

To create at text file simply insert a temporary table starting with "#_F_" in the SQL. Further setting for creating text files are available under the "Create csv file" settings: