Our training courses

Other training resources

Our training venues

Why we are different

Integration Services (SSIS) Training Courses

Enjoy our friendly but expert online or classroom SSIS courses, with small course sizes (maximum 6 people). With introductory, advanced and fast-track courses to choose from, plus lots of other Integration Services training resources, there's something on this page for everyone.

We currently run the following scheduled SSIS courses:

Not exactly the course contents you want? Why not consider organising your own tailored SSIS course)?

More about our Integration Services training

SQL Server Integration Services (SSIS) is what's called ETL software, standing for Extract, Transform and Load.  SSIS allows you to do the following:

Task

Notes

Extract

You can get data from a wide range of data sources (the course will concentrate 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.  The 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, the 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

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

In addition to the above, 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 whether this course is right for you, there's more help available for choosing here.

10 things our courses include

Each of our scheduled courses (whether classroom or online) includes:

  1. Small course sizes - we have a maximum of 6 people on each classroom or online course.
  2. A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
  3. Full colour courseware and exercises of oustanding quality.
  4. A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
  5. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a nice pen.
  6. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
  7. A certificate sent out digitally or in paper form (your choice) after each course, together with (for tailored courses) the trainer's thoughts on how the course went.

In addition, our classroom courses also include:

  1. A computer for each delegate (obviously).
  2. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  3. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.

Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.

Scheduled SSIS training dates

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

Course Dates Days Venue Price Booking
Introduction to SSIS Thu/Fri 04-05 April 2024 04-05 Apr 2 Online £825 Book places
Introduction to SSIS Mon/Tue 29-30 April 2024 29-30 Apr 2 Online £825 Book places
Fast track SSIS Wed/Fri 15-17 May 2024 15-17 May 3 Online £1,295 Book places
Introduction to SSIS Thu/Fri 30-31 May 2024 30-31 May 2 Online £825 Book places

All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite SSIS training at your offices (we'll even provide the computers and projector).

About our SSIS training

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.

Other Integration Services training resources

There are many ways in which we can help you learn SSIS!

Try our SSIS exercises

You can use the following Integration Services exercises either to practice before a course, or to assess your level of ability - or just for fun!

Blogs on SSIS

Looking for help with Integration Services? Some of these blogs may help.

Videos on SSIS

Choose to learn Integrated Services by watching our SSIS videos.

SSIS training venues

We run our Integration Services training at one the following venues.

SSIS courseware manuals

SSIS consultancy

As well as training on Integration Services, we also offer consultancy too.

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 2024. All Rights Reserved.

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