COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Advanced SSIS

Classroom Training

Advanced SSIS

Available as classroom training course only

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

2 days

The main thing that you'll learn from this advanced 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.

Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.

Course Contents

The contents of this course are as follows:

A quick C# primer

  • Writing methods
  • Using variables
  • Using namespaces

Script tasks

  • Message boxes
  • Setting return status

Variables in script

  • Passing variables in/out
  • Referencing in code

Script components

  • Input and output flows
  • Manipulating values in script

Sending mail

  • Limitations of the Send Mail task
  • The System.Mail namespace
  • Sending emails in code

Accessing file attributes

  • FileInfo and DirectoryInfo
  • Accessing file properties
  • Filtering by file date/time

Dynamic expressions

  • Using expressions for properties
  • Ideas for expressions to use

Advanced loops

  • Looping over XML files
  • Looping over items
  • FOR loops

Caching data

  • Cache connection managers
  • Using cache files in lookups

Using package parts

  • Storing components for reuse
  • Using package parts

Covered if time allows If time

Logging and auditing

  • Logging to text files
  • Logging to SQL Server
  • Audit transforms

Covered if time allows If time

Events

  • Creating an event
  • Pre- and post-execute events
  • Error-handling using events

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

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

"Pacing and level of course was spot on. Right mix of professionalism and humour."

Mark Tyrie (Waltham Forest Council)

"Great delivery of content at good pace. Ensured everyone stayed in pace. The exercises were great to work through to solidify the learning."

Mercy Otiena (Department for Education)

"The course was excellent. The trainer provided lots of useful tips and examples tailored to our requirements. The take-away material will be really useful as we capitalise on this training in our work."

Pat Watt (Skills Development Scotland (SDS))

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

"Good overall experience! Thorough course materials and excellent coverage of theoretical frameworks and practical exercises. Plenty of time dedicated to individual queries. The course was well paced and balanced between basic and more complex functions. I would like to thank the trainer for helping me with my specific queries."

Anthony Dodwell (JoJo Maman Bébé)

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

Related Courses

Introduction to SSIS

Introductory

2 day course

Reporting Services RECOMMENDED

Introductory

2 day course

Other 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