PostProcessing Tab

The PostProcessing Tab provides a way to setup processes that should happen after the import process is complete.

Examples:

Moving a file to a new location following the import.
Running an executable
Issuing SQL Statements on the DataSource.
Call an external batch or executable file to execute a SQL statement on another database.

Post Processing Tab


External Process(es)
Name	Enter the name of the post process.
Order	If there is more than one process enter a number for the order that each process should occur in.
Program **	Enter the program/command to run. Enter the path to the .exe or .bat file that you will run. Enter the SQL statement to be run on the data source if the data source supports SQL statements. Note: The path should not include " ".
Arguments **	Enter any parameters that will be passed to the program.
Every Record	Indicates if the process should occur after each record is imported or after the entire import process is completed. For example you may create a process that will update a web service with information from an imported record. In this case you will mark Every Record so that the process sends the information with every record that is imported.
Web Service	Mark if the post process is connecting to a web service.
SQL Statement	Mark if the post process is a SQL statement issued on the data source. The SQL statement is entered into the Program field.

* Supports using formulas. Must be enclosed in [[ ]]. Example: [[+GETDATE()]]

* If the Every Record box is checked these formulas also support mapping fields from the source data (ex '=A12') or Properties from the Imported record.