Use

SQL ELT optimization

to improve task performance by using the database resources. When you run a task configured for

SQL ELT optimization

, the task converts the transformation logic to a PolyBase query or SQL query. The task sends the query to the database, and the database executes the query.

Configure

SQL ELT optimization

for a mapping in the tasks properties.

You can configure

SQL ELT optimization

in task that references a mapping or a mapping in advanced mode.

If your mapping contains multiple pipelines, you can define the flow run order to load the targets from the pipelines in a particular order.