The DataDrivenQueryTask object contains information about specifying the use of individual queries instead of performing an INSERT operation at the destination. Data is read from the source and transformed, and a custom transformation returns an indicator, of which of up to four custom parameterized queries are executed on the destination, using the transformed values in the destination row. DataDrivenQueryTask is an implementation of a CustomTask object.
| DestinationColumnDefinitions Collection | SourceCommandProperties Collection |
| DestinationCommandProperties Collection | Transformations Collection |
| Lookups Collection |
| Execute Method |