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
Sven Aelterman 