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.

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
Packages
Control Flow
Data Flow
Variables
Parameters
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

How to Book

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

We will then contact you to confirm availability and any additional required details.