I can hardly believe I will be delivering From Zero To SSIS! in London, England 5-9 Mar 2012 – in less than a month! This course is delivered in cooperation with my friends at TechniTrain who provide awesome training by talented technologists like Chris Webb (Blog), Gavin Payne (Blog), and Christian Bolton (Blog). I hope to see you there! :{>

My mind was wandering today after reading Andy Leonard's excellent post Name Those Connections and it occurred to me that due to SQL Server 2012 including an SSIS Server there may be an opportunity to leverage Policy-Based Management (PBM) for ensuring adherance to an organisation's best practises around SSIS development. I have absolutely no idea ...

When creating Connection Managers in SSIS, take a moment to click the “All” page and set a value in the Application Name property. In SSIS 2008+, a default value is applied to this property. It’s useful but it contains a GUID. Yuck. I prefer to enter a more concise identifier like the one shown here:   “Why should I enter this ...

Although there are some audio issues, the recording and code for the Linchpin People microTraining session on SSIS Package Configurations is now live! :{>

I’ve released couple of hours ago the SP2 of my DTLoggedExec tool. For those who don’t know it, it’s a DTEXEC replacement, useful to execute SSIS and having logging provided right from the engine and not from the package itself. More info can be found here: http://dtloggedexec.codeplex.com/ This SP2 release add an important feature to the CSV ...

I will be delivering another free, online MicroTraining on SSIS Package Configurations Tuesday, 7 Feb 2012, at 10:00 AM EST. Join Andy Leonard as he demonstrates uses of SSIS Package Configurations for externalizing SSIS package variable values. Register here! :{>

Once upon a time I blogged at http://consultingblogs.emc.com/jamiethomson but that ended in August 2009 when I left EMC. There is a lot of (arguably) valuable content over there however certain events in the past leave me concerned that that content is not well cared for and I don't have any confidence that it will still exist in the long term. ...

I am honored to present Building Your First SSIS 2012 Package to the Madison Professional Association for SQL Server (MADPass) Wednesday, 25 Jan 2012! If you read this blog and will be in the Madison, Wisconsin area Wednesday, stop by and introduce yourself! I’m the fat guy with a fu. :{>

I am honored to be presenting A Day of SSIS Friday, 13 Apr 2012 – a precon for SQL Saturday 111 in Atlanta. There is early-bird pricing in effect until the Ides of March. You can register and view details of the course topics here. Jessica Moss and Adam Machanic are also delivering precons that day: Jessica’s is Learn SSRS in a Day and Adam’s, No ...

Join me for a microTraining session on SSIS Precedence Constraints! When? Wednesday, 11 Jan 2012, 10:00 AM ESTWhere? Please register here!What? SQL Server Integration Services Precedence Constraints provide many ways to control work-flow in the Control Flow. The price for flexibility? Complexity. Join me as I present options and patterns for ...