The Wise Owl logo (an owl and the company name)

Our training courses
AI - Articial Intelligence Azure C# Excel Microsoft 365 MySQL Power Apps Power Automate Power BI and DAX Python Report Builder SQL SQL Server VBA Macros

Other training resources
Tips and tricks Guides and tutorials Blogs Exercises YouTube tutorials YouTube shorts Test your skills Consultancy Courseware Self-paced courses Newsletters Publications

Our training venues
London Manchester Across the UK At your site Online

Why we are different
Hundreds of published reviews Small class sizes Outstanding courseware Online classroom (Almost) no cancellations Wise Owl trainers only Genuine integrity Invoices after training 30+ years of Wise Owl Our top 100 clients

Wise Owl's Integration Services (SSIS) Training Courses

Picture of a random Wise Owl trainer
Shaun (one of our 7 Wise Owl trainers)

Preferred venue/format

Over 50 Google 5-star reviews

528 attributed reviews

Benefits of our SSIS training

Not sure if we deserve all the reviews you can see on this site? Here are some of the things we do (very) differently to earn them.

Hidden
Hidden

Friendly and professional training ... guaranteeed▼

How can any training company guarantee the quality of their courses? Here's how:

  • We limit our courses to no more than 6 people per class.
  • Unlike almost every other computer training company, we never subcontract or use freelancers - here's why this matters.

The best courseware in the industry? See for yourself▼

Our course manuals and exercises are by some way the best in the computer training industry. Fortunately you don't have to take our word for this - you can see for yourself:

Genuine integrity - and good manners▼

Our values are simple - we treat people as we would like to be treated ourselves. So:

  • We will - almost never - cancel courses. To see what "almost never" means see our no cancel guarantee.
  • There's nothing worse than being pestered, so we don't pester people. Ever.
  • It's dangerous to be sanctimionius, but we can see no possible benefit that tobacco and gambling companies bring to the world (and quite a lot of harm), so we choose not to work for them. Sorry.

You can see more on our corporate values here.

Innovative online training platform▼

We've put a lot of thought into making our online courses as useful and interactive as possbile:

  • Delegates use Remote Desktop to connect to our machines, so our trainers can see everyone's screens at all time.
  • We arrange (without charge) a half-hour pre-course check for each online delegate before courses, to ensure that they everyone will be able to join the course seamlessly when it begins.
  • As well as providing a PDF of the manual and exercises for each online course delegate we will (again without charge) also post this out to each person a few days before if required.

Choose a specific course, or stay on this page to see all of our SSIS training.

Course:

Our current SQL Server Integration Services scheduled courses

Can't see the dates/course type that you want? Create your own onsite course (and tailor the content too!).

Course

Dates

Venue/type

Duration

Price

Times

  
We don't have any scheduled courses for this combination of criteria: please try different options.
Introduction to SSIS Mon/Tue 17-18 March 2025 17-18 Mar Online 2 days £875.00 + VAT 09:30-16:30 Book
Introduction to SSIS Wed/Thu 16-17 April 2025 16-17 Apr Online 2 days £875.00 + VAT 09:30-16:30 Book
Fast track SSIS Mon/Wed 12-14 May 2025 12-14 May Online 3 days £1,350.00 + VAT 09:30-16:30 Book
Introduction to SSIS Thu/Fri 15-16 May 2025 15-16 May Online 2 days £875.00 + VAT 09:30-16:30 Book
Introduction to SSIS Mon/Tue 16-17 June 2025 16-17 Jun Online 2 days £875.00 + VAT 09:30-16:30 Book
Introduction to SSIS Wed/Thu 16-17 July 2025 16-17 Jul Online 2 days £875.00 + VAT 09:30-16:30 Book
Fast track SSIS Wed/Fri 16-18 July 2025 16-18 Jul Online 3 days £1,350.00 + VAT 09:30-16:30 Book
Introduction to SSIS Thu/Fri 14-15 August 2025 14-15 Aug Online 2 days £875.00 + VAT 09:30-16:30 Book
Fast track SSIS Wed/Fri 10-12 September 2025 10-12 Sep Online 3 days £1,350.00 + VAT 09:30-16:30 Book
Introduction to SSIS Mon/Tue 15-16 September 2025 15-16 Sep Online 2 days £875.00 + VAT 09:30-16:30 Book
Introduction to SSIS Thu/Fri 16-17 October 2025 16-17 Oct Online 2 days £875.00 + VAT 09:30-16:30 Book
Fast track SSIS Wed/Fri 12-14 November 2025 12-14 Nov Online 3 days £1,350.00 + VAT 09:30-16:30 Book
Introduction to SSIS Mon/Tue 17-18 November 2025 17-18 Nov Online 2 days £875.00 + VAT 09:30-16:30 Book
Introduction to SSIS Thu/Fri 11-12 December 2025 11-12 Dec Online 2 days £875.00 + VAT 09:30-16:30 Book

If you can't see the course you want listed above, don't despair! If you can muster 3 or 4 people together, it may well be worth organising an onsite course at your office (we'll provide and set up the computers), or else an online course tailored to your needs.

Our SQL Server Integration Services classroom training venues

What other people have said about our SSIS training

Here are some comments we've received about our SSIS + training. You can see all of our 528 reviews here. We would like to sincerely thank the clients whose names are shown below for kindly agreeing to let us share their feedback.

"The Team all thought that the trainer had an excellent working knowledge of the subject and responded well to any queries we had. All in all a very positive experience. I chose the course off the back of an SSIS article I found online. The explanations in the article were excellent."

Michael Street

Hounslow & Richmond Community Healthcare NHS Trust

"The trainer was brilliant and very knowledgeable on the subject. He covered the course material at a good pace and was happy to answer any questions"

James Langrick

Southend-on-Sea City Council

"All good, very pleased and would use company again."

David Griffiths

Hounslow & Richmond Community Healthcare NHS Trust

"Good course structure and the trainer was excellent. Many thanks."

Dorothy Titus-Glover

Hounslow & Richmond Community Healthcare NHS Trust

"A lovely and approachable trainer with extensive knowledge."

Alicja Niedzwiedziuk

Southend-on-Sea City Council

"The course was really helpful, informative and covered all areas needed (and listed in the course guide). The trainer was easy to approach and to ask for help and a very effective trainer. This recent experience, along with past experience of Wise Owl, confirms that you're a great company. Your website is the first I go to whenever looking at future training."

Rebecca Kirkby

East Coast Community Healthcare CIC

About our SSIS training

SQL Server Integration Services (SSIS) is what's called ETL software, standing for Extract, Transform and Load. 

Our Introduction to SSIS course (two days)

SSIS allows you to do the following:

Task

Notes

Extract

You can get data from a wide range of data sources (our introductory course concentrates on SQL Server, Excel and CSV or text files, but the principles apply to any data source).

Transform

Integration Services includes a wide variety of data transforms.  Our introductory course will show you (for example) how to use data conversion transforms to convert data; derived column transforms to add new columns; lookup transforms to compare data against a master list; and conditional split transforms to split data according to some test that you execute against each row.

Load

Finally, you can send data to a variety of destinations, including SQL Server, Excel and text files.

In addition to the above, our two-day introductory course will show you how to work with files using file system tasks.  Here are some of the things you'll learn how to do:

What

Notes

Basic tasks

Creating folders and copying files.

Loops

Looping over all of the files in a folder.

Multiple imports

Looping over (for example) all of the workbooks in a folder, importing the data from each.

Our Advanced SSIS course (two days)

We also have a two-day advanced SSIS course, which concentrates on script tasks and script components in SSIS, teaching you how to write script like this:

public void Main()

{

// work out number of films

int gf = Convert.ToInt32(Dts.Variables["GoodFilms"].Value);

int bf = Convert.ToInt32(Dts.Variables["BadFilms"].Value);

int nf = gf + bf;

// show results

MessageBox.Show("There are " + nf.ToString() + " films");

Dts.TaskResult = (int)ScriptResults.Success;

}

We use C# rather than VB as a scripting language for several reasons, one of them being that this is the language used in SSIS expressions anyway.

The advanced course will also show how you can use SSIS to send mail, react to events, log data - and much more! 

If you consider yourself to be a fast learner, you might consider our fast-track SSIS course, which combines the introduction and advanced courses together into three intensive days. If you're still not sure which course is right for you, there's more help available for choosing here.

Here's a scenario where using Integration Services could not only free up your time, but also ensure that data was processed accurately too:

  1. Imagine that each month each division of your organisation submits results in a CSV file.  This contains a few free-text header lines which you always have to delete, then thousands of rows of transactions.

  2. You know that the data is often a bit iffy: dates come in a format which no other software application will read, and product names are frequently misspelt.

  3. You want to import all of the data into a single SQL Server table, cleaning it up in the process, then move the CSV files to an archive folder, renaming them in the process.

Integration Services would allow you to do all of the above in a single package, which would have the additional advantage of having a flow diagram clearly laid out showing the order of execution of the different tasks.

FAQs (Frequently Asked Questions

Click on any heading below to learn more.

How can I contact you with any questions?▼

You can reach us in one of the following ways:
Contact method Details
Phone Call us on (0161) 883 3606 and (within normal UK office hours) a friendly and helpful human will answer the phone!
Email Send an email to our inbox and we'll aim to answer it within a couple of working hours.
Web Fill in an enquiry form letting us know what you want to achieve, and we'll do our best to help!

Do you offer SSIS consultancy too?▼

As well as training on Integration Services, we also offer consultancy too: Get specific details about our SQL Server Integration Services consultancy, or more general information about how our consultancy works.

Do you have any SSIS videos?▼

We've got the following videos on our site to help you to learn SSIS:

Category Description Videos

Integration Services

As an alternative to attending our classroom SSIS course, you could follow this series of tutorials instead.

19

Do you ever blog about SSIS?▼

Looking for help with Integration Services? Some of these blogs may help:
Blog topic
Integration Services blogs
This page has 0 threads Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2025. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...