O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required