Business Intelligence training -  Fast track SSIS

SSIS Training

3-day fast track Integration Services (SSIS) course

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

  • 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

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

A quick C# primer

  • Training topicWriting methods
  • Training topicUsing variables
  • Training topicUsing namespaces

Script tasks

  • Training topicMessage boxes
  • Training topicSetting return status

Variables in script

  • Training topicPassing variables in/out
  • Training topicReferencing in code

Script components

  • Training topicInput and output flows
  • Training topicManipulating values in script

Covered if time allows If time

Sending mail

  • Training topicLimitations of the Send Mail task
  • Training topicThe System.Mail namespace
  • Training topicSending emails in code

Covered if time allows If time

Accessing file attributes

  • Training topicFileInfo and DirectoryInfo
  • Training topicAccessing file properties
  • Training topicFiltering by file date/time

Covered if time allows If time

Logging and auditing

  • Training topicLogging to text files
  • Training topicLogging to SQL Server
  • Training topicAudit transforms

Events

  • Training topicCreating an event
  • Training topicPre- and post-execute events
  • Training topicError-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?

View full list of benefits View full list of benefits

Sample customer feedback

"The manuals are very informative and well put together and the exercises ensure that the training makes sense."

William Watson (Restons Solicitors Limited)

"The trainer was brilliant and explained tasks well and answered questions."

Sophie Green (Canal & River Trust)

"Intense but v enjoyable thank you - much learnt!"

Matt Dowdy (Leeds College of Music)

"I was very impressed with the course training, the small group size and the material that we covered. I benefitted from the trainer spending extra time going through the report grouping sessions and I will be using these and extra skills in my work. In future I may consider Integration Services and Advanced SQL."

Simon Young (Derbyshire County Council)

"Interesting and relevant content. Good pace. Friendly trainer. Thanks."

Michelle France (Pinsent Masons LLP)

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