Skip Ribbon Commands
Skip to main content
SharePoint

Saving the Results to a File

To save the results as an XML to a file, complete the following:
  1. Check out and open the process you want to edit.
     
  2. Open the Execute SQL activity.
     
  3. Click the Save Results to File tab. The corresponding window is displayed.
     
  4. Click the Save Results as XML to File check box in order to activate the following fields.
     
  5. Select an editor for the Output File Name field and set it to hold the name of the file. By default, the Literal Value editor is set.
     
  6. Select an editor for the File Location field and set it to the path to which you want the file to be saved. By default, the Folder Browser editor is set.
     
  7. In the Authentication section, select Run as BPM or Specify Credentials.
     
    Note:
    If you select Run as BPM Server, access will be granted or rejected based on the BPM Server credentials.
    If you select Specify Credentials, complete the Username, Password, and Include domain fields using the appropriate input field editors. The Include domain check box is optional.

     
  8. Click OK. You configured the activity to save the results as XML to a file.
     
Related Topics
Executing SQL Statements and Stored Procedures
Rolling Back and Removing New Records when an Error Occurs

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Database Activities > Execute SQL
Last modified at 7/31/2020 11:56 AM