Home
%3CLINGO-SUB%20id%3D%22lingo-sub-388111%22%20slang%3D%22en-US%22%3ESSIS%202012%3A%20Creating%20a%20Simple%20ETL%20Package%20Tutorial%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388111%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Dec%2018%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EThere%20is%20now%20a%20SSIS%202012%20version%20of%20the%26nbsp%3B%22Creating%20a%20Simple%20ETL%20Package%20Tutorial%22.%20The%20tutorial%20and%20lesson%20packages%20work%20with%20the%20AdventureWorksDW2012%20database.%20And%2C%20the%20tutorial%20includes%20a%20new%20Lesson%206%20that%20shows%20you%20how%20to%20convert%20a%20project%20to%20the%20project%20deployment%20model%20and%20replace%20configuration%20values%20with%20parameters.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThe%20tutorial%20documentation%20is%20at%20%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms169917.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20SSIS%20Tutorial%3A%20Creating%20a%20Simple%20ETL%20Package%20%3C%2FA%3E%20.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ETo%20download%20the%20lesson%20packages%20and%20sample%20data%20for%20the%20tutorial%2C%26nbsp%3Bnavigate%20to%20the%20%3CA%20href%3D%22http%3A%2F%2Fmsftisprodsamples.codeplex.com%2Freleases%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20DOWNLOADS%20%3C%2FA%3E%20tab%20of%26nbsp%3Bthe%20%3CSTRONG%3E%20Integration%20Services%20Product%20Samples%20%3C%2FSTRONG%3E%20project%20on%26nbsp%3BCodePlex%20and%20click%26nbsp%3Bthe%20SQL2012.Integration_Services.Create_Simple_ETL_Tutorial.Sample.zip%20file.%26nbsp%3B%20To%20download%20the%20AdventureWorksDW2012%20database%2C%20navigate%20to%20the%20%3CA%20href%3D%22http%3A%2F%2Fmsftdbprodsamples.codeplex.com%2Freleases%2Fview%2F55330%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Adventure%20Works%20for%20SQL%20Server%202012%20%3C%2FA%3E%20release%20on%20the%20%3CSTRONG%3E%20Database%20Product%20Samples%20%3C%2FSTRONG%3E%20project%20on%20CodePlex.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThis%20%3CA%20href%3D%22http%3A%2F%2Fmsftisprodsamples.codeplex.com%2Fwikipage%3Ftitle%3DSS2012%2521Creating%2520a%2520Simple%2520ETL%2520Package%2520Tutorial%253a%2520Lesson%2520Packages%26amp%3BreferringTitle%3DHome%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20samples%20readme%20%3C%2FA%3E%20provides%20additional%20information%20about%20running%20the%20lesson%20packages.%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-388111%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Dec%2018%2C%202012%20There%20is%20now%20a%20SSIS%202012%20version%20of%20the%26nbsp%3B%22Creating%20a%20Simple%20ETL%20Package%20Tutorial%22.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388111%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Essis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Essis%202012%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Not applicable
First published on MSDN on Dec 18, 2012

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 SQL2012.Integration_Services.Create_Simple_ETL_Tutorial.Sample.zip 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.