The DataDrivenQueryTask object reads data through a source Connection object and transforms it using one or more Transformation objects. One of the transformations, a DataPumpTransformScript object, returns an indicator that determines which of four parameterized queries is executed on the destination Connection object. For more information, see Adding DTS Transformations and Adding DTS Column Objects.
The queries are called the Insert query, Update query, Delete query and User query, although they do not actually need to be used for these purposes. Any sequence of SQL action statements and stored procedure calls can be used for any of the queries. The query parameters are columns from the destination connection. For more information, see Adding DTS Query Strings.
|Lookups Collection||Transformations Collection|