Guru's Guide to SQL Server Architecture and Internals, The

The Data Driven Query Task

In a simpler world, basic DML would be sufficient to transfer data between two sources. Data transformation would consist mostly of one-to-one column copies, and you'd rarely need to employ any sort of complex logic to determine how and whether data should be copied from one place to another. In the real world, however, complex logic is often behind the methods used to move data from place to place, and stored procedures and custom queries are often necessary to get the job done. The Data Driven Query task exists for these types of situations. If you have a data transformation need wherein you require more functionality than simply inserting rows into a destination table, a Data Driven Query task may fit the bill. For ...