SSIS Introduction

Course Duration is 2 Days

£895.00 Plus VAT

Business Benefit

As Data size grows and more terabyte sized data warehouses are becoming common place within organisations, data controllers need more efficient data handling techniques rather than the traditional T-SQL and stored procedures. SSIS fits this position and offers data controllers a range of tools to help them manage the flow of data.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking.

Who Should Attend

The course is designed for anyone new to using SSIS and what to learn from the beginning best practice and understand the available tools.

Learning Outcomes – by the end of this course you will be able to…

Understand the key concept of SSIS
Work with the main tools within the SSIS Architecture
Appreciate Data Flows
Understand ETL packages

Course Content

SSIS Introduction & Historical Overview
SSIS Architecture
Control Flow
Data Flow
Error Handling & Logging
The SSIS Package Designer
SSIS Tasks
SSIS Task Objects
Looping & Sequence Tasks
Data Mining Query Tasks
Data Preparation Tasks
RDBMS Server Tasks
Workflow Tasks
SMO Administration Tasks
Understanding the Data Flow
Common Transformations
Typical Mainframe ETL with Data Scrubbing
Joining Data
Accessing Heterogeneous Data