Classroom training -  Fast track SSIS

Classroom Training

3-day fast track Integration Services (SSIS) course

Available as classroom training course only

3 days

For most people our two-day introduction to SSIS course will suffice to meet their Integration Services training needs, but to cater for those who want to hoover up as much knowledge as possible in as short a time as possible we've created this three-day intensive SSIS course, including units also from our advanced SSIS course.  Go from zero to SSIS hero in three intensive days!

Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our INTRODUCTION TO SSIS course

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

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

Although you don't need any knowledge of SQL Server to attend this course, you will find life easier if you know how to write a basic SQL statement.  What you must have, however, is a very good aptitude for computing (the course's three days will pass very slowly if you don't!).

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

"The trainer was fantastic - very engaging and informative. Excellent training - thank you."

Victoria Elliott (Bloom Services)

"An excellent course, well delivered with a knowledgeable tutor."

Graham Davies (Lex)

"Brilliant, well paced and pitched at the correct level for beginners as a true 'introduction.' Work related course, other colleagues previously attended and recommended."

Jess Flint (Derby and Burton Hospitals NHS FT)

"Will find content very useful. Great to be able to take queries saved with me. Lunches were great. (Since the training I have actually used some of the saved queries as templates for queries I have run at work.)"

Paul Thompson (Cheshire Datasystems Ltd)

"The course exceeded my expectations. I learnt a lot!"

Darren Campbell (Servochem (PTY) Ltd)

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

Related Courses

Introduction to SSIS

Basic

2 day course

Advanced SSIS RECOMMENDED

Advanced

2 day course

Other Integration Services training resources

SSIS exercises

SSIS exercises

You can see all of the exercises that we've published for Integration Services here.

View SSIS exercises

SSIS videos

SSIS videos

As an alternative to classroom training, you could learn SSIS from our many videos.

View Integration Services videos

SSIS blogs

SSIS blogs

Read the blogs we've published on Integration Services on our website.

View SSIS blogs

This page has 0 threads Add post