Classroom Training

Advanced SSIS

Classroom training course - online version also available

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

Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.

Course Contents - PDF

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

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

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
534 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

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"My trainer was patient, kind, respectful and very understanding about my needs. I was taught a lot in one day. "

Patricia Young (Muse Developments)

"As a novice to Excel the course was simple to follow with good instruction and direction. Coming away I felt I had learnt so much and having the full course interactive makes a massive difference as you are physically navigating and completing the tasks yourself rather than watching and listening to the trainer. Coming away with all the notes, workbooks and completed exercises is great as well as I can keep testing myself regularly."

Jamie Westcott (Greater Manchester Combined Authority (GMCA))

"The trainer was very informative and enthusiastic. He explained things well and went through things in detail. The course was interesting and has helped me understand SSIS better."

Shivani Thakar (BAE Systems)

"An amazing trainer, very knowledgeable and professional (he is funny as well). Overall Wise Owl have delivered the best training I've ever had. My manager recommended Wise Owl in the first place. After my SQL and Power BI training I know why he speaks so highly of you guys. We are very happy with the trainings provided. Looking forward to coming back. Thank you all!"

Cristina Schmidt (Wiggin LLP)

"Really good pace and content. Can't wait to try all the things I've learnt. Good reviews from past users. Content was appropriate to my needs."

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

Related Courses

Introduction to SSIS

Introductory

2 day course

Reporting Services RECOMMENDED

Introductory

2 day course

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

This page has 0 threads Add post