To enable social distancing we've completely remodelled our classroom training, launched a full range of live online courses and now provide online training-cum-consultancy.
Classroom training -  Introduction to SSIS

Classroom Training

SSIS for Beginners

Classroom training course - online version also available

£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 coursesPossible locations:London, Manchester, Online
  • Next Introduction to SSIS course locationNext classroom course:Thu 30 July 2020
  • Introduction to SSIS course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

SSIS basics

  • Solutions and projects
  • Basic packages
  • Control and data flow tasks
  • The 32-bit question

Data flow tasks

  • Connection managers
  • Sources and destinations

Using different data connections

  • SQL Server (OLEDB)
  • Connecting to Excel workbooks
  • New and existing flat files
  • Multiple flat files

Data viewers

  • Attaching data viewers
  • Data buffers

Basic data transforms

  • Sorting and aggregating
  • Sampling data
  • Dividing and uniting data

Data conversion transforms

  • The SSIS data types
  • Unicode and ASCII data
  • Type cast functions

Variables and expressions

  • The Row Count transform
  • User and system variables
  • Expression tasks

Debugging

  • Setting breakpoints
  • The Locals window

Derived column transforms

  • SSIS expressions
  • Using SSIS functions
  • Using the conditional operator

Handling errors

  • Redirecting and ignoring errors
  • Truncation errors

Conditional split transforms

  • Splitting data by expression
  • Using comparison operators
  • Syntax for multiple conditions

Lookup transforms

  • Redirecting unmatched rows
  • Choosing a cache mode
  • Setting unmatched rows to Unknown
  • Adding unmatched rows automatically

File system tasks

  • Working with files
  • Working with folders

Looping over files

  • The file name variable
  • Configuring the loop
  • Expression constraints

Importing multiple files

  • Using expressions for connections
  • Dynamic connections within loops

Covered if time allows If time

Looping over rows

  • Object variables
  • Reading in data
  • Looping over ADO rows
  • Dynamic connection strings

Using parameter placeholders

  • Using the ? Symbol
  • Mapping parameters

Merge joins

  • How they work
  • Comparing two data sets

Basic deployment

  • Project-level deployment
  • Creating a catalog
  • Deploying and viewing in SSMS

Covered if time allows If time

Using parameters

  • Package and project parameters
  • Using parameters in expressions
  • Deploying parameters
  • Why 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?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Great content and delivery method."

Antonio Martin-Cobos (CHEP UK Ltd)

"Well-paced, good sample data, honest advice and excellent trainer - would recommend to others & look at additional courses."

Dan Hodgson (Oldham Council)

"Very well delivered course. Perfect level for an introduction."

Van Macintosh (DHU Healthcare CIC)

"Excellent as always."

Lisa De Prudhoe (DataQ Ltd)

"Great training environment and very good trainer. Well paced course that included time to cover additional topics."

Steven Ford (Canterbury Christ Church University)

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 classroom Introduction to SSIS courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 30-31 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
30/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