SQL University– SSIS 2012: Deploying Projects –Lesson One

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:

  1. Projects
  2. Project Deployment Model
  3. Legacy Deployment Model
  4. Project Reference reference type –Execute Package Task
  5. Ispac files
  6. 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 😉

  1. Execute SQL Task
  2. Execute Package Task
  3. Connection Managers
  4. Variables
  5. 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. Continue reading

Finally, a PowerShell script I can get excited about!

Aaron Nelson (Blog | Twitter) and I have a little game we like to play where we drink beer and talk smack about each other’s favorite platform. I’m (mostly) an SSIS developer.  He’s a (SQL Server) PowerShell guy.  He’s always calling SSIS bloated and inferior, while my position is that PowerShell, while handy for many things, is just not suited for ETL work beyond straight-copy-data-pushes.

But today I found a PowerShell feature that I and all of my hard core ETL developer compadres can really get behind:  the ability to script the creation of an Environment Variable.

Continue reading