COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Introduction to SSIS

Classroom Training

SSIS for Beginners

Classroom training course - online version also available

£695 + VAT for most venues (£850 + VAT for London)

2 days

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams! 

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

Course details

  • Locations for Introduction to SSIS coursesPossible locations:London, Manchester, Online
  • Next Introduction to SSIS course locationNext classroom course:Thu 11 February 2021
  • Introduction to SSIS course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

SSIS basics

  • Solutions and projects
  • Basic packages
  • Control and data flow tasks
  • The 32-bit question

Data flow tasks

  • Connection managers
  • Sources and destinations

Using different data connections

  • SQL Server (OLEDB)
  • Connecting to Excel workbooks
  • New and existing flat files
  • Multiple flat files

Data viewers

  • Attaching data viewers
  • Data buffers

Basic data transforms

  • Sorting and aggregating
  • Sampling data
  • Dividing and uniting data

Data conversion transforms

  • The SSIS data types
  • Unicode and ASCII data
  • Type cast functions

Variables and expressions

  • The Row Count transform
  • User and system variables
  • Expression tasks

Debugging

  • Setting breakpoints
  • The Locals window

Derived column transforms

  • SSIS expressions
  • Using SSIS functions
  • Using the conditional operator

Handling errors

  • Redirecting and ignoring errors
  • Truncation errors

Conditional split transforms

  • Splitting data by expression
  • Using comparison operators
  • Syntax for multiple conditions

Lookup transforms

  • Redirecting unmatched rows
  • Choosing a cache mode
  • Setting unmatched rows to Unknown
  • Adding unmatched rows automatically

File system tasks

  • Working with files
  • Working with folders

Looping over files

  • The file name variable
  • Configuring the loop
  • Expression constraints

Importing multiple files

  • Using expressions for connections
  • Dynamic connections within loops

Covered if time allows If time

Looping over rows

  • Object variables
  • Reading in data
  • Looping over ADO rows
  • Dynamic connection strings

Using parameter placeholders

  • Using the ? Symbol
  • Mapping parameters

Merge joins

  • How they work
  • Comparing two data sets

Basic deployment

  • Project-level deployment
  • Creating a catalog
  • Deploying and viewing in SSMS

Covered if time allows If time

Using parameters

  • Package and project parameters
  • Using parameters in expressions
  • Deploying parameters
  • Why to avoid environments

You should have a basic knowledge of SQL Server to attend this course (you don't necessarily need to know how to write a SELECT statement, but you should have seen one before).  This course uses SQL Server 2016 (although if you're using 2012 or 2014 you'll find it just as useful, as there are virtually no differences between the versions).

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"The trainer was very informative and enthusiastic. He explained things well and went through things in detail. The course was interesting and has helped me understand SSIS better."

Shivani Thakar (BAE Systems)

"Really enjoyed the courses, I thought the trainer was excellent, not only knowledgeable but personable too."

Stephen Groves (Volac International Ltd)

"Well-paced, good sample data, honest advice and excellent trainer - would recommend to others & look at additional courses."

Dan Hodgson (Oldham Council)

"Good overview. Course detailing all basics of SSIS, covering wide base of topics and a trainer willing to use extra time to cover additional topics."

Chris Kehoe (Rural Insurance)

"Really excellent course - a brilliant (& entertaining) trainer. Good pace, good explanation. Will definitely be recommending when I get back to the office! Good introduction to SSIS - excellent course outline on website. Recommendation came from manager."

Elspeth Clark (Central and North West London (CNWL) NHS Foundation Trust)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Introduction to SSIS training dates

Here are the classroom Introduction to SSIS courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 11-12 February 2021 2 £695 Book places
Tue/Wed 23-24 February 2021 2 £850 Book places
Thu/Fri 15-16 April 2021 2 £695 Book places
Tue/Wed 18-19 May 2021 2 £850 Book places
Tue/Wed 08-09 June 2021 2 £695 Book places
Thu/Fri 08-09 July 2021 2 £850 Book places
Thu/Fri 29-30 July 2021 2 £695 Book places
Date(s) Venue
11/02
23/02
15/04
18/05
08/06
08/07
29/07

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SSIS training at your offices (we'll even provide and set up the computers).

Related Courses

Reporting Services

Introduction

2 day course

Introduction to SQL

Basic

2 day course

Advanced SSIS RECOMMENDED

Advanced

2 day course

Other Integration Services training resources

SSIS exercises

SSIS exercises

We've published all of our Integration Services exercises online to allow you to inspect them before booking this introduction to SSIS course.

View SSIS exercises

SSIS videos

SSIS videos

You can learn particular aspects of creating SSIS packages by following one of the videos we've created and put online.

View Integration Services videos

SSIS blogs

SSIS blogs

Have a look at the various blogs we've published on all things SQL Server Integration Services.

View SSIS blogs

This page has 0 threads Add post