SQL Server training -  Advanced SSIS

SSIS Training

Advanced SSIS (2 days)

£795 + 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

"Overall very useful. Pre-course information was friendly."

Nadeer Khan (Parabis)

"Showed structure and importance of data model, with lots of practical examples, answered specific requests of most attendees and best lunches I've ever had on a course."

Rainer Pratl (CFA Institute)

"The facilities were very good, especially lunch and the choice of coffee and snacks!"

Ian Greenwood (Oberthur Technologies UK Ltd.)

"Really brought the subject matter to life. Energetic, funny, relevant, focused."

Martin Ward (Warner Bros Entertainment UK Ltd)

"Good pace and very clear. Good having small groups."

Amanda Green (Globe Business Publishing)

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