SQL Server Integrations Services - SSIS (online)

Training

Online

£ 725 + VAT

Description

  • Type

    Training

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    12h

  • Duration

    2 Days

  • Start date

    Different dates available

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Personal tutor

    Yes

  • Virtual classes

    Yes

SQL Server Integration Services (often abbreviated to SSIS) allows you to automate the import, export and conversion of data. Whether you want to fill your data warehouse each evening with that day's transactions (whatever they may be) - or simply learn how SSIS fits into the wider SQL Server picture - this course is for you!

Refreshingly, the course doesn't use any large, impenetrable Microsoft database, but instead uses a simple Wise Owl one, and the exercises use simulated examples of real-life tasks.

Important information

Documents

  • Introduction to SSIS course outline.pdf

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SSIS basics
  • Data flow tasks
  • Using different data connections
  • Data viewers
  • Basic data transforms
  • Data conversion transforms
  • Variables and expressions
  • Debugging
  • Derived column transforms
  • Handling Errors
  • Conditional split transforms
  • Lookup transforms
  • File system tasks
  • Looping over files
  • Importing multiple files

Teachers and trainers (4)

Andrew Gould

Andrew Gould

Senior Trainer

Andy Brown

Andy Brown

Microsoft Trainer & Programmer

Sam Lowrie

Sam Lowrie

Trainer

Shaun Wantling

Shaun Wantling

Trainer

Course programme

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

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

If time

Using parameters
  • Package and project parameters
  • Using parameters in expressions
  • Deploying parameters
  • Why to avoid environments

SQL Server Integrations Services - SSIS (online)

£ 725 + VAT