WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
Classroom training -  Introduction to SSIS

Classroom Training

SSIS for Beginners

Classroom training course - online version also available

£850 + VAT for most venues (£995 + VAT for London)

2 days

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams! 

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

Course details

  • Locations for Introduction to SSIS coursesPossible locations:London, Manchester, Online
  • Next Introduction to SSIS course locationNext classroom course:No classroom dates
  • Introduction to SSIS course timesTime:09:30-16:30

Course Contents

The contents of this course are as follows:

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

Covered if time allows If time

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

You should have a basic knowledge of SQL Server to attend this course (you don't necessarily need to know how to write a SELECT statement, but you should have seen one before).  This course uses SQL Server 2016 (although if you're using 2012 or 2014 you'll find it just as useful, as there are virtually no differences between the versions).

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

"Best IT course I've done! Content was great, price reasonable and the person I was emailing for information was very helpful."

Rebecca Kirkby (East Coast Community Healthcare CIC)

"I was pleasantly surprised with the virtual training as I have always preferred classroom teaching and also very happy with the course. It was very hands on, which I appreciated more that just being talked to. I was impressed with my instructor too. He was very engaging. I liked the course content."

Folakemi Ayoade (Bank of England)

"Really excellent course - a brilliant (& entertaining) trainer. Good pace, good explanation. Will definitely be recommending when I get back to the office! Good introduction to SSIS - excellent course outline on website. Recommendation came from manager."

Elspeth Clark (Central and North West London (CNWL) NHS Foundation Trust)

"Well-paced, good sample data, honest advice and excellent trainer - would recommend to others & look at additional courses."

Dan Hodgson (Oldham Council)

"Thank you for being so patient with me."

Patricia Amadi (Gravesham Borough Council)

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

Related Courses

Reporting Services

Introduction

2 day course

Introduction to SQL

Basic

2 day course

Advanced SSIS RECOMMENDED

Advanced

2 day course

Other Integration Services training resources

SSIS exercises

SSIS exercises

We've published all of our Integration Services exercises online to allow you to inspect them before booking this introduction to SSIS course.

View SSIS exercises

SSIS videos

SSIS videos

You can learn particular aspects of creating SSIS packages by following one of the videos we've created and put online.

View Integration Services videos

SSIS blogs

SSIS blogs

Have a look at the various blogs we've published on all things SQL Server Integration Services.

View SSIS blogs

This page has 0 threads Add post