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 trainer was great - first Excel course I've actually enjoyed and learnt about things I will realistically use going forward!"

Laura Page (Shazam Entertainment Limited)

"The trainer was very well informed, keen to help and able to communicate the topics clearly & at the right pace."

Craig Murphy (Coloplast Ltd)

"Very good - covers a lot of areas in detail but also efficiently."

Flora Mclean (Refuge)

"Surprisingly fun and interesting. Very well done and organised. The trainer was very enthusiastic and very good at answering unique questions with on the spot examples."

Thomas Felton (PricewaterhouseCoopers Services Ltd.)

"Enjoyed the course and learnt a lot. We had a great tutor and he created a relaxed environment and made participation and questions easy. Also lunch was great. (Advised by a colleague who had previously attended a course.)"

Andrew Whaling (Muse Developments)

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