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

"Brilliant manual, contents and delivery."

Jennifer Dias (CNA Hardy)

"Excellent course, highly engaging and personal trainer. Good mix of teaching and exercises. Could not recommend higher!"

Matt Jackson (Liberty Retail plc)

"I would like to say that I enjoyed the course very much and found it very informative. The trainer was incredibly professional and helped explain all the elements in the SSRS Course, ensuring that we fully understood each topic before moving on. I really liked the fact that the trainer explained multiple methods of achieving the same outcome in the use of SSRS as it helped us all to find what method was best suited for us. The course was really well structured and I didn’t feel rushed when completing the exercises, which were an added benefit as they allowed us to expand on the skills we were learning during the training. The course was beneficial to my personal development and I have already begun applying the training in my role. The supporting documents provided have also been great in helping me implement the training in practice."

Matt Hardy (Derbyshire County Council)

"I found the course excellent. Very helpful and explained everything well."

Sandra Ashton (AQA Education Limited)

"The course is very well structured and the trainer is very patient and ready to help! It is a very useful training."

Greta Cipriano (Provident Financial Management Services Ltd)

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