SSIS 2012: Creating a Simple ETL Package Tutorial

There is now a SSIS 2012 version of the "Creating a Simple ETL Package Tutorial". The tutorial and lesson packages work with the AdventureWorksDW2012 database. And, the tutorial includes a new Lesson 6 that shows you how to convert a project to the project deployment model and replace configuration values with parameters.

The tutorial documentation is at SSIS Tutorial: Creating a Simple ETL Package.

To download the lesson packages and sample data for the tutorial, navigate to the DOWNLOADS tab of the Integration Services Product Samples project on CodePlex and click the file.  To download the AdventureWorksDW2012 database, navigate to the Adventure Works for SQL Server 2012 release on the Database Product Samples project on CodePlex.

This samples readme provides additional information about running the lesson packages.

Comments (9)

  1. Great ETL tutorial ! I found it very useful.

  2. Tim Raczek says:


    I downloaded the SQL Server 2012 Express and expected to be able to do the tutorial for SSIS.  I was wrong.  

    In the first step at:…/ms365299(v=sql.105).aspx

    It says 1.On the Start menu, point to All Programs, point to Microsoft SQL Server, and click SQL Server Business

    Intelligence Development Studio.

    I could not find "SQL Server Business Intelligence Development Studio" to click on.  

    What do I need to do?

    Tim Raczek

  3. Tim, you need the version of Visual Studio called SQL Server Data Tools (Business Intelligence). It comes with the SQL Server 2012 installation. Alternatively, you can download the Visual Studio 2012 version here:…/details.aspx

  4. If there are tutorial for each and every tasks in SSIS ,it would be really helpful for beginners


  5. This was one of the improvements we did in 2012! Click on any task/transform in the SSIS Toolbox – you'll see a link to "Find Samples".

  6. Emil says:


    Here is an SSIS 2012 Tutorial for beginners with over 200 videos so far

    Take care


  7. Sreehari says:


    Suppose my system has 8GB RAM and I have installed SQL Server 2012 on it along with the DataTools. Sql server engine uses 6GB memory. Will the SSIS uses remaning memory apart from 6GB or it uses 6GB?

    Also is there a way to count the number of buffers used and the records accomodated in each buffer and the size of the buffer?

    If am not wrong buffer refers to the RAM memory?

  8. Yannick says:

    I own a sql server express 2012 AND a sql server enterprise 2012.

    I'd like to use the express version as a client (on my laptop) and use it to develop SSIS jobs.

    I read that this is possible, if you have a remote server running mssql Enterprise. The fact is that I have no idea of how to tell my express server to connect to the Enterprise version, and enable me to use SISS.

    I get the error :

    "Microsoft Visual Studio is unable to load this document: To design Integration Services packages in SQL Server Data Tools (SSDT). SSDT has to be installed by one of these editions of SQL Server 2012: Standard. Enterprise. Developer, or Evaluation. To install SSDT, run SQL Server Setup and select SQL Server Data Tools."

  9. ZappySys says:

    Thanks for sharing this tutorial. Out the box SSIS is pretty good but anyone find things missing we have great collection of SSIS Tasks and Transforms tasks…/ssis-powerpack

Skip to main content