queryToFile Step

Last published at: May 14th, 2024


Executes an SQL query against the selected database and return the results in file.


  • name - step name
  • connectionString – connection string to the database
  • sqlQuery – SQL query to execute
  • resultFileFormat – return results in selected file format
  • varGlobalFilePath - Specifies the file path for the output
  • changeDatabase - connect to different Database


  • True – SQL query executed successfully
  • False – SQL query failed to execute



Let’s build and execute the querytofileDef example.          

  • Create a new definition called “querytofileDef
  • Select the definition and click the “design” button
  • Drag a querytofile step from the toolbox
  • Connect the dots between the start and querytofile step
  • Click on the “querytofile” step to configure its properties
  • Configure the following values for the properties as shown on the below graphic
  • Save the process definition, create a process instance and execute. The step should create file from SQL results. 
  • The column headers in the output excel file matches the columns specified in the SQL query with regards to text case.