Classroom training course - online version also available
£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).
Rebecca Salmon (The Cambridge Building Society)
Caroline Brenier (University of the Arts London Awarding Body)
Lyndsey Thiele (Department of Health)
Adrian Dilworth (Torus (Housing Trust))
Julie Ross (Thurrock Council)
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