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