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:Tue 07 March 2017
  • 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

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

David Gott (City of Lincoln Council)

"Trainer was very good, with an informal delivery. Good selection of refreshments. Meal out was good touch; better than cheap sandwiches. Location is literally 2 mins from Piccadilly."

Stephen Hope (UK General Insurance)

"The course notes and exercise were really good and enjoyable. The instructions were really clear and the instructor very helpful and knowledgeable."

Zulfikar Mohammed (Virgin Media)

"I saw the excellent tutorials of Wise Owl on the web and that prompted me to do a course."

Emma Charles (Holman Fenwick Willan)

"Good pace and explanations. Mix of exercises good too. I’m now booked in for the SSIS course in a few weeks, which is testament to the quality of the course!"

Steven Sharp (Penguin Random House Group Ltd)

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