Skip to main content


Showing posts from September, 2012

SQL Server 2012 Integration Services Design Patterns

A book, a pre-conference training session, and a webinar - oh my! The Book Over the past two years, I have been lucky enough to work with some of the great SSIS-gurus, Andy Leonard , Matt Masson , Tim Mitchell , and Michelle Ufford , on a book project that has finally been realized.  I am pleased to announce the publication of SQL Server 2012 Integration Services Design Patterns ( amazon | apress ).  Thank you to everyone who helped with the writing, editing, and reviewing of the book. The Pre-conference Training Session The PASS Summit has invited the ENTIRE author team to give a pre-conference training session on Monday, November 5, 2012.  This training session gives you the chance to ask anything you want from the author team and take home advanced knowledge that can immediately be implemented.  SSIS Design Patterns description: In this full-day session, the "SSIS Design Patterns" (Apress, 2012) author team – Matt Masson, Tim Mitchell, Jessica M. Moss, Michelle

Upgrading and Overhauling SSIS Q&A

Thank you to everyone who attended my School of Wrox presentation "Upgrading and Overhauling Your SSIS Packages for 2012" last month.  There were many remaining questions at the end of the session that we weren't able to fit.  The questions below are the unaddressed ones asked during the session that are specific to upgrading to 2012.  Enjoy! Will SSIS 2008 package run AS IS in 2012? Yes, the SSIS 2012 service will temporarily convert the package in its 2005 or 2008 format to the 2012 format when the package runs.  The package may not execute properly if it references providers or assemblies that are not available, so upgrading the package before deploying is highly recommended.  For more information, see: . Can we integrate file based execution in catalog in DB and generate reports about the executions? Storing packages for execution on the file system is only possible in the Package Deployment Model.  To util