Protect your training budget AND save money with our new pre-payment vouchers.
Classroom training -  Fast track SSIS

Classroom Training

3-day fast track Integration Services (SSIS) course

Classroom training course - online version also available

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
From our ADVANCED SSIS course

A quick C# primer

  • Writing methods
  • Using variables
  • Using namespaces

Script tasks

  • Message boxes
  • Setting return status

Variables in script

  • Passing variables in/out
  • Referencing in code

Script components

  • Input and output flows
  • Manipulating values in script

Covered if time allows If time

Sending mail

  • Limitations of the Send Mail task
  • The System.Mail namespace
  • Sending emails in code

Covered if time allows If time

Accessing file attributes

  • FileInfo and DirectoryInfo
  • Accessing file properties
  • Filtering by file date/time

Covered if time allows If time

Logging and auditing

  • Logging to text files
  • Logging to SQL Server
  • Audit transforms

Events

  • Creating an event
  • Pre- and post-execute events
  • Error-handling using events

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

"As the most inexperienced person in the room I felt SSRS is very friendly and the trainer made sure I kept up and understood each part of the course."

Amanda Newton (North East Lincolnshire Council)

"The trainer was really helpful and was watching our every move on the remote sessions to make sure we were OK and not lagging behind. Top bloke, really nice, really good experience. Thank you so much! "

Adam Ratcliff (Whitemeadow Furniture Ltd)

"(SSIS) Enjoyed the training; examples clear and concise; thanks to the trainer for helping investigate particular issues that we had, in his own time, on top of the training. (SSRS) Very useful to be able to tailor the course to our requirements. Many thanks to the trainer for responding so quickly to our questions which went quite a long way off topic."

Lucy Gooda (The Cambridge Building Society)

"The trainer was very engaging and delivered the training in a way that was informative and easy to follow. The course content was varied and very useful."

Sherry Goodman (Advanced Business Software and Solutions)

"Very relaxed, yet informative course that covered a wide range of topics."

Ben Robinson (Manchester University NHS Foundation Trust)

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