ETLGEN / USER GUIDE
Build an ETL specification
Describe sources, business rules, and destination columns in one reviewable model.
Start with SQL when it helps
The Query to Specification command can turn a T-SQL query into an initial source, filter, and column layout. Paste the query itself when converting a stored procedure, rather than only its name.
Model the sources
Add one source at a time. Select a connection, choose a table, view, derived query, flat file, or fully qualified table, then give it a unique alias. Add joins after the source tables are present.
Apply filters
Use the ETL filter section for WHERE and HAVING logic. ETLGen separates aggregate conditions where possible and supports windowed expressions such as row_number() over (...).
Define destination columns
For each column, set its name and data type, choose the source alias, and write the ETL rule. Mark identity and unique columns carefully: unique columns drive change detection and lookup behavior.
Use Save while the model is incomplete. When it is ready, use Save and Generate Package to create the target artifacts and any required table script.