Browse 556 attributed reviews, viewable separately for our classroom and online training
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!

Course details

  • Locations for Fast track SSIS coursesPossible locations:London, Manchester, Online
  • Next Fast track SSIS course locationNext classroom course:No classroom dates
  • Fast track SSIS course timesTime:10.00-16.30

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

"The trainer was really thorough and explained the various topics well. He was also very friendly and approachable which made it very easy to ask questions. I look forward to completing future Wise Owl courses."

Natalie Sheard (Alzheimers Research UK)

"Good content taught well, engaging and surprisingly useful. Top teacher, friendly & made the courses as fun as possible. Thanks for the cake!"

Akaash Rajput (PricewaterhouseCoopers)

"Really enjoyed the courses, I thought the trainer was excellent, not only knowledgeable but personable too."

Stephen Groves (Volac International Ltd)

"I thought this was a really well run, well presented & useful course. Our trainer was excellent and clearly very knowledgeable. He managed to keep the course entertaining and maintained energy levels throughout the course which is very impressive given he was running the course remotely. I thought the pace of the course was good and requiring participants to continually work alongside the trainer really helped me concentrate and practice the SQL skills. Finally I was impressed by Wise Owl's organisation in ensuring that there were no IT issues by checking connections etc in advance. Thank you!"

Jen Steel (East of England Co-op)

"An amazing course that was really informative and enjoyable. Would have loved it if it was longer as I would have liked more time to practice! An amazing trainer - really friendly and patient and explained things really well. (SQL) Another brilliant course. Full of content and easily explained with lots of examples. This will be incredibly helpful in my role of producing reports & summaries for staff at all levels. (SSRS) I really couldn’t praise the training, or the trainer, enough. Not only will the training be absolutely invaluable in my work (SQL and SSRS), but I can honestly say it was the most enjoyable training I have ever done as well!"

Ann Laing (Thurrock Council)

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