This page has 0 threads | Add post

Wise Owl's Integration Services (SSIS) Training Courses

Rick (one of our 7 Wise Owl trainers)

Preferred venue/format

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

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	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 521 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 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

"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:

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.
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.
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
SSIS

This page has 0 threads

Add a new post