Create a new specification

Choose the target

Select Azure Data Factory or SSIS. SSIS settings include the package deployment model and an optional template. ADF settings include the integration runtime and credential configuration.

Define the destination

Choose a destination connection and table. Mark This is an existing table when the target already exists; otherwise ETLGen can generate DDL for it. Use a unique pipeline or package name.

Choose load behavior

• Insert and Update loads new rows and changes.
• Truncate and Reload clears the destination before loading all rows.

For updates in SSIS, choose whether comparison rows live in a temporary or regular table. Compare every column or use a SHA2 hash when that is more efficient for the data.

Continue to the editor

Select Save and Continue. You can return to these settings later from the specification details section.