SSIS Introduction
£895.00 Plus VAT (per person)
Have more than 2 delegates? Talk to us about our closed group courses.
Delivery Method
Open Public Courses – Virtual Delivery Only Closed Group Courses – Face To Face and Virtual Delivery
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
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
Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking by Credit Card or via Invoice. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.
The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!
Post-course, to evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. This additional session lasts for 2.5 hours.
During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.
We compile this information into a report so that you have evidence of your return on investment.