561 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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:
SQL Server Integration Services (SSIS) is what's called ETL software, standing for Extract, Transform and Load. SSIS allows you to do the following:
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).
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.
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:
Creating folders and copying files.
Looping over all of the files in a folder.
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.
Each of our scheduled courses (whether classroom or online) includes:
In addition, our classroom courses also include:
Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.
Here are the SSIS courses we have scheduled for the next 3 months:
|Introduction to SSIS||16-17 Jan||Online|
|Fast track SSIS||05-07 Feb||Online|
|Introduction to SSIS||22-23 Feb||Online|
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).
Here's a scenario where using Integration Services could not only free up your time, but also ensure that data was processed accurately too:
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.
There are many ways in which we can help you learn SSIS!
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!
Looking for help with Integration Services? Some of these blogs may help.
Choose to learn Integrated Services by watching our SSIS videos.
As well as training on Integration Services, we also offer consultancy too.
25 Aytoun Street