ETL Process to Populate Warehouse Structures
Copy Config File and Set Environment Variable
Master ETL Package (BBDW_ETL.dtsx)
Key Points in Your SSIS Package
Add an SSIS Package from an Existing Package
Package Template: Pre Processing Sequence
Package: Set ETL Run Variables Task
Package Template: Load Rows Sequence
Package: Truncate Staging Task
Package: Load Changed Rows Task
Package: Adding Staging Indices Task
Package Template: ETL Post Processing Sequence
SSIS Packages Project Template
Open the SSIS Extensions Project
Add SSIS Package Exercise Steps
SSIS Package Exercise: View ETL Run Variables Task and Referenced Stored Procedure
SSIS Package Exercise Steps: View ETL Run Variables Task and Referenced Stored Procedure
SSIS Package Exercise: Modify Truncate Staging Task
SSIS Package Exercise Steps: Modify Truncate Staging Task
SSIS Package Exercise: Load Changed Rows Task
SSIS Package Exercise Steps: Load Changed Rows Task
SSIS Package Exercise: Adding Staging Indices Task
SSIS Package Exercise Steps: Adding Staging Indices Task
SSIS Package Exercise: Upsert Task
SSIS Package Exercise Steps: Upsert Task
SSIS Package Exercise: Adding Indices Task
SSIS Package Exercise Steps: Adding Indices Task