SQL Server Integration Services (SSIS)

Understand the core concepts, architecture, and benefits of SQL Server Integration Services.

• Overview and Core Concepts
• Architecture Deep Dive
• Installation and Setup

Explore the essential components and functionalities that make SSIS a robust ETL tool.

• Control Flow Tasks and Logic
• Data Flow Transformations
• Connection Managers

Follow guided examples to build your first SSIS packages.

• Building a Simple Data Transfer Package
• Applying Common Data Transformations
• Deploying and Executing Packages

Design the workflow and execution logic of your SSIS packages.

• Tasks (Execute SQL, File System, Script, etc.)
• Precedence Constraints
• Event Handlers

Extract, transform, and load data with a rich set of transformations.

• Data Sources
• Transformations (OLE DB, Flat File, Derived Column, etc.)
• Data Destinations

Manage package configurations, execution, and monitoring.

• Package Parameters and Variables
• Expressions
• Deployment Models (Project vs. Package)
• SSIS Catalog (SSISDB)

Optimize your SSIS packages for speed and efficiency.

• General Performance Guidelines
• Identifying and Resolving Bottlenecks
• Leveraging Parallelism

Implement robust error handling and logging mechanisms.

• Data Flow Error Outputs
• Package Event Logging
• Custom Logging Solutions

Extend SSIS functionality with custom components and scripts.

• Script Component (C# / VB.NET)
• Developing Custom Tasks
• Developing Custom Transformations