SQL Server training -  Integration Services

SSIS Training

Integration Services (2 days)

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

SQL Server Integration Services (often abbreviated to SSIS) allows you to automate the import, export and conversion of data. Whether you want to fill your data warehouse each evening with that day's transactions (whatever they may be) - or simply learn how SSIS fits into the wider SQL Server picture - this course is for you!

Refreshingly, the course doesn't use any large, impenetrable Microsoft database, but instead uses a simple Wise Owl one, and the exercises use simulated examples of real-life tasks.

Course details

  • Locations for Integration Services coursesLocations:London, Manchester
  • Next Integration Services course locationNext course:Thu 03 November 2016
  • Integration Services course timesTime:09.30-16.30

Course Contents

SSIS basics

  • Training topicSolutions and projects
  • Training topicBasic packages
  • Training topicTwo ways to run packages

Data flow tasks

  • Training topicConnection managers
  • Training topicSources and destinations
  • Training topicExcel, OLEDB and flat files

Data transformations

  • Training topicSorting and aggregating
  • Training topicFully and partially blocking
  • Training topicSampling data

Data viewers

  • Training topicAttaching data viewers
  • Training topicUsing dead-end destinations


  • Training topicThe Row Count transform
  • Training topicSystem variables
  • Training topicChanging scope


  • Training topicExpression syntax
  • Training topicData types and casting
  • Training topicConditional split transforms
  • Training topicDerived column transforms

Lookup transforms

  • Training topicFull and partial caching
  • Training topicRedirecting unmatched rows
  • Training topicCache Connection Managers


  • Training topicFour types of container
  • Training topicBasic FOR loops

Foreach loops

  • Training topicLooping over files
  • Training topicLooping over records
  • Training topicOther foreach loops


  • Training topicScript tasks
  • Training topicScript components
  • Training topicThe variable dispenser

Controlling flow

  • Training topicPrecedence constraints
  • Training topicEvent-handling

Managing errors

  • Training topicRedirecting and ignoring errors
  • Training topicDealing with truncations

Covered if time allows If time

Overview of logging

  • Training topicLogging to text files
  • Training topicLogging to SQL Server


  • Training topicProject-level deployment
  • Training topicCreating an SSIS Catalog

Parameters and environments

  • Training topicPackage and project parameters
  • Training topicCreating and using environments

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Manual excellent and detailed; trainer brilliant, patient and knowledgeable."

Martin Howells (Institute of Education, University of London)

"Excellent courses which covered everything I wanted to learn and then some. The exercises challenging and interesting. The subject data is a very good idea and appeals to users from any background. This will be my last course for now – I’ve got used to the Minshull Street site! I can’t recommend the courses enough, great site, great trainers, great content. Hopefully my colleagues will be coming to you in the future."

David Bell-Hartley (UHSM NHS Foundation Trust)

"Excellent trainer and material. Venue perfect as right next to hotels and transport links."

David Gott (City of Lincoln Council)

"Excellent course."

Stuart Gregory (Macquarie Energy Leasing)

"Very good course. Learnt a lot!"

Stephen Du Bois (Chartered Society of Physiotherapy)

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

You must have a basic understanding of SQL and SQL Server to attend this course (you don't need to be a rocket scientist; just be able to navigate your way round a SELECT statement).  This course uses SQL Server 2012 (although if you're using 2014 you'll find it just as useful, as there are virtually no differences between the versions).

If you're using SQL Server 2008 R2 you should be aware that there are differences between the versions, but it is our opinion that 80-90% of the course will still be useful.  Alternatively, you could consider booking onsite training in SSIS 2008 R2 (or even 2005!).

Related Courses

Reporting Services


2 day course

Introduction to SQL


2 day course



2 day course

Other SQL Server 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