Classroom Training
Advanced SSIS
Classroom training course - online version also available
£950 + VAT for most venues (£1,095 + 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
Using package parts
- Storing components for reuse
- Using package parts
If time
Logging and auditing
- Logging to text files
- Logging to SQL Server
- Audit transforms
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?
- No more than 5 people per class
- Proper restaurant lunch included
- 481 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
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).
Ellie Richardson (BUPA)
Shiv Haria (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))
Solomon Odunlami (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))
Deanne Yates (Manchester University NHS Foundation Trust)
Shaun Rowark (NICE (National Institute for Health & Care Excellence))
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Integration Services training resources
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
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
Have a look at the blogs that we publish intermittently on Integration Services.
View SSIS blogs