Business Intelligence training -  Introduction to SSIS

SSIS Training

SSIS for Beginners Training Course

£695 + VAT for most venues (£850 + VAT for London)

2 days

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams! 

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

Course details

  • Locations for Introduction to SSIS coursesLocations:London, Manchester
  • Next Introduction to SSIS course locationNext course:Tue 19 November 2019
  • Introduction to SSIS course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

SSIS basics

  • Training topicSolutions and projects
  • Training topicBasic packages
  • Training topicControl and data flow tasks
  • Training topicThe 32-bit question

Data flow tasks

  • Training topicConnection managers
  • Training topicSources and destinations

Using different data connections

  • Training topicSQL Server (OLEDB)
  • Training topicConnecting to Excel workbooks
  • Training topicNew and existing flat files
  • Training topicMultiple flat files

Data viewers

  • Training topicAttaching data viewers
  • Training topicData buffers

Basic data transforms

  • Training topicSorting and aggregating
  • Training topicSampling data
  • Training topicDividing and uniting data

Data conversion transforms

  • Training topicThe SSIS data types
  • Training topicUnicode and ASCII data
  • Training topicType cast functions

Variables and expressions

  • Training topicThe Row Count transform
  • Training topicUser and system variables
  • Training topicExpression tasks

Debugging

  • Training topicSetting breakpoints
  • Training topicThe Locals window

Derived column transforms

  • Training topicSSIS expressions
  • Training topicUsing SSIS functions
  • Training topicUsing the conditional operator

Handling errors

  • Training topicRedirecting and ignoring errors
  • Training topicTruncation errors

Conditional split transforms

  • Training topicSplitting data by expression
  • Training topicUsing comparison operators
  • Training topicSyntax for multiple conditions

Lookup transforms

  • Training topicRedirecting unmatched rows
  • Training topicChoosing a cache mode
  • Training topicSetting unmatched rows to Unknown
  • Training topicAdding unmatched rows automatically

File system tasks

  • Training topicWorking with files
  • Training topicWorking with folders

Looping over files

  • Training topicThe file name variable
  • Training topicConfiguring the loop
  • Training topicExpression constraints

Importing multiple files

  • Training topicUsing expressions for connections
  • Training topicDynamic connections within loops

Covered if time allows If time

Looping over rows

  • Training topicObject variables
  • Training topicReading in data
  • Training topicLooping over ADO rows
  • Training topicDynamic connection strings

Using parameter placeholders

  • Training topicUsing the ? Symbol
  • Training topicMapping parameters

Merge joins

  • Training topicHow they work
  • Training topicComparing two data sets

Basic deployment

  • Training topicProject-level deployment
  • Training topicCreating a catalog
  • Training topicDeploying and viewing in SSMS

Covered if time allows If time

Using parameters

  • Training topicPackage and project parameters
  • Training topicUsing parameters in expressions
  • Training topicDeploying parameters
  • Training topicWhy to avoid environments

You should have a basic knowledge of SQL Server to attend this course (you don't necessarily need to know how to write a SELECT statement, but you should have seen one before).  This course uses SQL Server 2016 (although if you're using 2012 or 2014 you'll find it just as useful, as there are virtually no differences between the versions).

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Really worth while course. Very glad I did it. Brilliant trainer, would recommend to anyone. Very knowledgeable and enthusiastic. Great feedback on your website. Great location and course choice/content. Very good value for money."

Duncan Barber (DBS Datamarketing Ltd)

"The trainer was very informative and enthusiastic. He explained things well and went through things in detail. The course was interesting and has helped me understand SSIS better."

Shivani Thakar (BAE Systems)

"Well structured & informative. The trainer was very helpful and patient with my endless questions. Third time with Wise Owl, so knew what I was in for!"

Jonathan Brindley (DHU Healthcare CIC)

"Knowledgeable trainer, able to go 'off script', excellent course content."

Adam Hayter (The Southern Co-operative)

"Training material and delivery were superb. The trainer answered all my questions and made sure I understood the exercises in detail. I have already recommended Wise Owl to colleagues at work."

Bal Singh (MDSL International)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Introduction to SSIS training dates

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

Dates Days Venue Price Booking
Tue/Wed 19-20 November 2019 2 £850 Book places
Tue/Wed 03-04 December 2019 2 £695 Book places
Tue/Wed 14-15 January 2020 2 £850 Book places
Tue/Wed 21-22 January 2020 2 £695 Book places
Thu/Fri 20-21 February 2020 2 £850 Book places
Thu/Fri 05-06 March 2020 2 £695 Book places
Tue/Wed 07-08 April 2020 2 £850 Book places
Tue/Wed 28-29 April 2020 2 £695 Book places
Thu/Fri 28-29 May 2020 2 £850 Book places
Thu/Fri 18-19 June 2020 2 £695 Book places
Thu/Fri 09-10 July 2020 2 £850 Book places
Tue/Wed 28-29 July 2020 2 £695 Book places
Tue/Wed 11-12 August 2020 2 £850 Book places
Thu/Fri 17-18 September 2020 2 £695 Book places
Thu/Fri 08-09 October 2020 2 £850 Book places
Thu/Fri 29-30 October 2020 2 £695 Book places
Tue/Wed 24-25 November 2020 2 £850 Book places
Thu/Fri 10-11 December 2020 2 £695 Book places
Date(s) Venue
19/11
03/12
14/01
21/01
20/02
05/03
07/04
28/04
28/05
18/06
09/07
28/07
11/08
17/09
08/10
29/10
24/11
10/12

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SSIS training at your offices (we'll even provide and set up the computers).

Related Courses

Reporting Services

Introduction

2 day course

Introduction to SQL

Basic

2 day course

Advanced SSIS RECOMMENDED

Advanced

2 day course

Other 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