Learn ETL skills by learning how to use SSIS. This SSIS training course gives you the tools for data movement in SQL Server and data warehouses. We cover off the basics, then create a package from end-to-end. We consider the problems with loading dimension and fact tables, if required.

Learning Outcomes

SSIS, architecture, SSIS Toolbox, the data flows, sources, destinations, and problems moving data. This is a hands-on course.

Course Requirements

Power Users, Excel Users, Data Warehouse Developers or Complete Beginners.

Course Length

1-day

• Import and Export Wizard
• Data Tools
• SSIS Toolbox

• Control Flow
• Data Flow
• Variables
• Parameters

• Script Task
• Data Flow Task
• Workflow Tasks

• Data Sources
• Destinations
• Common Transforms
• Variables, Parameters and Expression
• Containers & Joining

• Precedence & Events
• Errors & Logging

• ETL
• Dimension Loads
• Fact Table Loads
• SSAS Processing

Course Price

This course costs £475 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!