Roadmap › 2. Database, ETL & BI › Step 31
IS
SSIS — SQL Server Integration Services
Packages, control flow and data flow, connection managers, variables and parameters, containers, transformations, lookups, SCD, error handling, logging, checkpoints, deployment models, SSISDB catalog, scheduling and performance tuning.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: Package Basics
- 1.Package anatomy: control flow vs data flowBasic ★ Must know
- 2.Connection managersBasic ★ Must know
- 3.Variables, parameters and expressionsBasic ★ Must know
- 4.Precedence constraintsBasic Medium
Module 2: Data Flow
- 5.Sources and destinationsBasic ★ Must know
- 6.Transformations and their typesIntermediate ★ Must know
- 7.Lookup transformation and cache modesIntermediate ★ Must know
- 8.Implementing incremental loads and SCD in SSISIntermediate ★ Must know
Module 3: Error Handling, Logging and Restartability
- 9.Error outputs, event handlers and loggingIntermediate ★ Must know
- 10.Checkpoints and transactionsIntermediate Medium
Module 4: Deployment, Scheduling and Performance
- 11.Project vs package deployment model and SSISDBIntermediate ★ Must know
- 12.Script Task and Script ComponentIntermediate Medium
- 13.Performance tuningAdvanced ★ Must know
Next course in the roadmap: 32. SSRS — SQL Server Reporting Services →