This Saturday I will be giving my first ever SQL Saturday presentation. I am excited (and nervous) to be doing something that I would not have even considered two to three years ago. If you are in Madison, Wisconsin this weekend and want to learn about SQL Server for free there will be a lot of great speakers. There are diverse SQL topics ranging from First Contact with MDX and Databases in the Cloud to How to Abuse T-SQL and Using SQL Window Functions. And if you are interested in learning about SSIS Configurations come listen to me at 8am. Since there are no breakfast pastries available for us this time around I will have Pop-Tarts for people who ask questions.
As with most things in the IT world there is more than one way to skin the SSIS configuration cat.* I’ll focus on SQL Server 2008 methods (being called Package Deployment method in SQL 2012) and show how to use 1)XML config files or 2)an environment variable or registry entry that points to a config database. I’ll also give a brief overview of the new project deployment method in SQL 2012. *[No cats were skinned in the making of this presentation.]