Data Flow in a Data Driven Query Task

Data Flow in a Data Driven Query Task

When you use a Data Driven Query task, the data flows as follows:

1. Rows are selected from the source.
   
   
2. Each row is transformed by the Microsoft® ActiveX® script (and possibly additional transformations). The return value of the ActiveX script determines which query will be selected later.
   
   
3. The results of the transformation are mapped to the binding table. Nothing is written to the destination at this time. The binding table is used to determine the attributes of the columns (for example, data type, scale, precision) that will be used by the parameterized queries in the next step.
   
   
4. For each row, the values in the binding table are mapped into the selected query, and the query is executed.
   
   
5. The query execution writes the row to the destination.

See Also

Using ActiveX Scripts in DTS

Using Parameterized Queries in DTS

Using Return Codes in DTS