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).
Patricia Young (Muse Developments)
Jamie Westcott (Greater Manchester Combined Authority (GMCA))
Shivani Thakar (BAE Systems)
Cristina Schmidt (Wiggin LLP)
Caroline Brenier (University of the Arts London Awarding Body)
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