Online Course: SSIS Advanced Techniques Workshop

5 Sessions Brought to you by SSWUG.ORG

Course Overview

In 2005 Microsoft introduced SQL Server Integration Services, SSIS, as their primary ETL (Extract, Transform, and Load) tool. SSIS fully integrates with the Common Language Runtime, CLR, and provides a platform for building enterprise-level data integration and data transformations solutions. Integration Services includes a number of built-in tasks and transformations as well as tools for constructing packages and the service for running and managing packages. You can use SQL Server Data Tools, SSDT, to create solutions without writing a single line of code; or you can write managed code using the Integration Services object model to create packages programmatically or code custom tasks and other package objects.

This workshop focuses on some of the more advanced topics within Integration Services including:
1. SSIS – Creating dynamic packages
2. SSIS – Error handling and troubleshooting
3. SSIS – Deployment models
4. SSIS – Replacing dynamic SQL with variables and expressions in SSIS
5. SSIS – Leveraging the Execute SQL task in SSIS

Each separate session provides in depth discussion and demonstrations on each of outlined topics to provide a better understanding of the subject matter and the tools necessary to be able to apply these techniques in your environment.

Watch Video

Course Structure/Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the sessions, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members, $199 for non-members and free for PRO members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.


Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

Other Events

  • Does your company have more than 1 person interested in this class? Take advantage of immediate savings by completing the group registration process. To start the group registration process downoad our form here.


    David Dye

    David’s primary focus and expertise is with SQL Server, reporting services, integration services, and analysis services, and he was recognized f...