Business Intelligence training - Advanced SSIS

SSIS Training

Advanced SSIS Training Course

£750 + VAT for most venues (£895 + 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 (or consider an onsite SSIS training course).

Course Contents - PDF

Course Contents

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

Caching data

Cache connection managers
Using cache files in lookups

Using package parts

Storing components for reuse
Using package parts

Covered if time allows If time

Logging and auditing

Logging to text files
Logging to SQL Server
Audit transforms

Covered if time allows If time

Events

Creating an event
Pre- and post-execute events
Error-handling using events

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
572 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"Trainer was very enthusiastic and engaging. Am very pleased with the course content and delivery. Course handout material is very useful to take away."

Kiran Thiara (Freemans Grattan Holdings)

"Excellent course material and delivery. Good solid foundation level for understanding of SQL structure and query."

Lee Ross (Peel Ports Limited)

"Enjoyed the course and learnt a lot. We had a great tutor and he created a relaxed environment and made participation and questions easy. Also lunch was great. (Advised by a colleague who had previously attended a course.)"

Andrew Whaling (Muse Developments)

"Excellent course, very well run, taught at a good pace for everyone. Tutor happy to answer any questions and provide support when required. Found you on Google search - saw all the positive review."

Bryan Fuller (Dixons Carphone)

"We had an excellent trainer, patient, knowledgeable and engaging. I would certainly recommend this course to a friend."

Alistair Smalley (Weybourne Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

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).