Lesson One, where I introduce tons of prerequisite new concepts in preparation for Deploying and Executing in Lesson Two. The main concepts and terms covered in this lesson are:
- Projects
- Project Deployment Model
- Legacy Deployment Model
- Project Reference reference type –Execute Package Task
- Ispac files
- Parameters, subdivided into the two following subtypes:
- Project Parameters
- Package Parameters
It will help if you are familiar with the following concepts inside SSIS (pre 2012 versions) before attempting this course 
- Execute SQL Task
- Execute Package Task
- Connection Managers
- Variables
- Parent/Child packages
SSIS in 2012 brings a great number of significant changes. It is the first version since its initial release with SQL Server 2005 to look significantly different. There is a more modern look and feel to be sure. However, the really big change to SSIS in 2012 is in the way in which it is deployed. There is a new method of deployment called “Project Deployment”, which has as much to do with how and where a package is deployed as it does with how a package is bundled during development. Let me go back in time a bit and explain. Read the rest of this entry »
