You are here:

Query Integration process Settings

A Query Integration (IP) runs when the source query in the DTS returns at least one row. At each specified polling interval, the Process executes the source query and determines the number of rows in the result set. If no rows are returned, the Process remains active and waits for the next polling interval. If one or more rows are returned, the job is queued.

Note:

By design, a Query IP only opens the source connection specified in the DTS to execute the source query. If the source query contains any formulas or functions that use another connection, the query fails. For example, if the source query contains a SQL Query function that uses a target connection, the source query fails.

In Run DTS query every, specify how frequently the Event Manager looks for the query results while the Process is active. The valid range is 1-9999 seconds.
In DTS Execution, specify when the DTS should run. One of:
- Run DTS once when query returns row(s) — Only run the Integration Process (IP) once when the query returns any rows.
- Run DTS every time query returns row(s) — Run the IP each time any rows are returned.