£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 content 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).
Marion Israel (Warner Bros Entertainment UK Ltd)
Dan Charlish (Tech21)
Pat Watt (Skills Development Scotland (SDS))
Rachel Mak (NHS Brent CCG)
Dan Paterson (Oldham 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