SQL Server training -  Advanced SSIS

SSIS Training

Advanced SSIS (2 days)

£750 + VAT for most venues (£895 + VAT for London)

The main thing that you'll learn from this 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

A quick C# primer

  • Training topicWriting methods
  • Training topicUsing variables
  • Training topicUsing namespaces

Script tasks

  • Training topicMessage boxes
  • Training topicSetting return status

Variables in script

  • Training topicPassing variables in/out
  • Training topicReferencing in code

Script components

  • Training topicInput and output flows
  • Training topicManipulating values in script

Sending mail

  • Training topicLimitations of the Send Mail task
  • Training topicThe System.Mail namespace
  • Training topicSending emails in code

Accessing file attributes

  • Training topicFileInfo and DirectoryInfo
  • Training topicAccessing file properties
  • Training topicFiltering by file date/time

Dynamic expressions

  • Training topicUsing expressions for properties
  • Training topicIdeas for expressions to use

Advanced loops

  • Training topicLooping over XML files
  • Training topicLooping over items
  • Training topicFOR loops

Caching data

  • Training topicCache connection managers
  • Training topicUsing cache files in lookups

Using package parts

  • Training topicStoring components for reuse
  • Training topicUsing package parts

Covered if time allows If time

Logging and auditing

  • Training topicLogging to text files
  • Training topicLogging to SQL Server
  • Training topicAudit transforms

Covered if time allows If time

Events

  • Training topicCreating an event
  • Training topicPre- and post-execute events
  • Training topicError-handling using events

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Excellent trainer and course."

Ramune Power (Rochdale MBC)

"We had an excellent tutor; we covered a lot of material and he paced it just right."

Chris Murphy (The Camping and Caravanning Club)

"Great communication with the booking team and course trainer. The menu is extremely detailed which will allow me to practice after the course has finished. The exercises are also invaluable."

Bomi Okuyiga (Home Office)

"Brilliant, well explained, easy to read manual. Really enjoyed it."

Helen Grazier (Ishida Europe Ltd)

"Really enjoyed the course and loved going out for lunch. I thought the course was very well organised and the setting exceeded my expectation with tea, coffee, snacks and sweets and then being taken out for lunch was a real bonus. The content of the course and Tutor were also great. Thanks."

Kelly Hall (Linney Group 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).

Related Courses

Introduction to SSIS

Introductory

2 day course

Reporting Services RECOMMENDED

Introductory

2 day course

Other SQL Server Integration Services training resources

SSIS exercises

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

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

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