SQL Server training -  Advanced SSIS

SSIS Training

Advanced SSIS (2 days)

£795 + VAT for most venues (£895 + VAT for London)

The main thing that you'll learn from this course is how to use script tasks (in control flow) and script components (in data flow) to validate data, send mail, check file attributes and much more.  The course uses C# for its scripting language (as for various reasons you should too).  In addition to scripting, the course also includes a smorgasbord of other topics, such as creating dynamic property values and logging packages to SQL Server.

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking  (or consider an onsite SSIS training course).

Course Contents

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

Sending mail

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

Accessing file attributes

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

Dynamic expressions

  • Training topicUsing expressions for properties
  • Training topicIdeas for expressions to use

Advanced loops

  • Training topicLooping over XML files
  • Training topicLooping over items
  • Training topicFOR loops

Caching data

  • Training topicCache connection managers
  • Training topicUsing cache files in lookups

Using package parts

  • Training topicStoring components for reuse
  • Training topicUsing package parts

Covered if time allows If time

Logging and auditing

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

Covered if time allows If time

Events

  • Training topicCreating an event
  • Training topicPre- and post-execute events
  • Training topicError-handling using events

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"I saw the excellent tutorials of Wise Owl on the web and that prompted me to do a course."

Emma Charles (Holman Fenwick Willan)

"Awesome!"

Marc Saxon (Manchester Royal Infirmary)

"The trainer is excellent - highly recommended. The website is great and informative."

Leigh Nelson (Temporis Capital LLP)

"Very useful exercises and explanations."

Diego Salinas (APPE Europe)

"Very good, the trainer was excellent. Speed of content was perfect. Movies database also very good and interesting!"

Christopher Brown (Merseycare NHS Trust)

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

You should only consider attending this course if you've attended our two-day introduction to SSIS course, or if you have a thorough understanding of how to create sources, destinations and transforms in SSIS.  The course uses SSIS 2016, but is also suitable for anyone using SQL Server 2012 or 2014 (there are very few differences).

Related Courses

Introduction to SSIS

Introductory

2 day course

Reporting Services RECOMMENDED

Introductory

2 day course

Other SQL Server Integration Services training resources

SSIS exercises

SSIS exercises

We've published our Integration Services online, so you can test your skills to see if you know the product as well as you thought!

View SSIS exercises

SSIS videos

SSIS videos

As an alternative (or supplement) to classroom learning, we've published a series of free tutorials on SSIS online.

View Integration Services videos

SSIS blogs

SSIS blogs

Have a look at the blogs that we publish intermittently on Integration Services.

View SSIS blogs

This page has 0 threads Add post