Rhode Island – SSUG – October 2015

I am driving thru America’s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on October 14, 2015. Check out the meetup for more details.

I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn.

Here is the gritty details of the presentation that I will be covering that night.


Simplistic design patterns with the SQL Server Stack


Integration Services is a great development environment for ETL developers. However, if you are new to ETL tools, there are so many tasks, objects and properties that can be used to design a solution.

Where do you start?

The purpose of this talk is to introduce simplistic design patterns to perform common tasks.

I will be talking about five real world examples and exploring the design choices to solve each one.


1 – Define ETL process.

2 – The Import/Export wizard for excel file load.

3 – The dtexec and dtexecui utilities.

4 – Benefits of the SSIS Catalog.

5 – Revisiting the excel file load.

6 – Last time looking at this package.

7 – Talk about three types of transformations.

8 – Use the database engine to sort, add columns, aggregate and/or merge when possible.

9 – Bad vs Good design – slowly changing dimensions

10 – Temporary work files.

11 – Summary of patterns

Presentation Bundle

Related posts

Leave a Comment