Available as classroom training course only
£750 + VAT for most venues (£895 + VAT for London)
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.
The contents of this course are as follows:
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).
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Barry Stanworth (9Brand Foods Limited)
Sarah Middlebrough (Medical Protection Society)
Mark Roberts (National Nuclear Laboratory)
Nicola Leah (Shell International Trading and Shipping Company Ltd.)
Thomas Critchley (Ministry of Housing, Communities and Local Government)
There are lots more where these came from (or just refresh this page to change the quotes shown).
View SSIS exercises
View Integration Services videos
View SSIS blogs