Updating the SSIS Tutorial: Creating a Simple ETL Package to SQL Server 2012

Edit/Update (2012-12-11): MSDN has now published a 2012 version of the same tutorial: http://msdn.microsoft.com/en-us/library/ms169917(v=sql.110).aspx

For SQL Server 2008 R2 Integration Services, Microsoft created a series of tutorials (http://msdn.microsoft.com/en-us/library/ms167031(v=sql.105).aspx). One of those was a nice step-by-step example of creating a basic ETL package.

When I teach the undergraduate data warehousing class at Troy University, I have students complete the first two lessons in that tutorial as their first foray into SSIS. With the release of SQL Server 2012 and the SSIS goodness it brings, I wanted to teach the class using SQL Server 2012. Even though SQL Server 2012 was released in March 2012, the tutorial hasn’t been updated yet.

While SSIS in SQL Server 2012 has lots of feature enhancements, I believed that the first two lessons could easily be adapted to the new SSIS. I didn’t look at further lessons in that tutorial, but they may be a little more involved, considering things like configurations and logging are introduced. Those features have seen more changes because of the new project deployment model.

I was able to walk through the tutorial and while doing so simply keeping track of minor changes in a Word document (see below). In general, the changes boil down to the SSIS Toolbox replacing the default Visual Studio Toolbox as the location of components and controls, including the SSIS Toolbox’ approach of categories for organization, and the color of the arrows. There are a few areas where a few SSIS defaults have changed, but only one that actually matters for the tutorial.

The Microsoft Word document is located here (on SkyDrive): http://sdrv.ms/S7aKqw

by Sven Aelterman

Let me know what you think, or ask a question...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.