AndyLeonard.blog()

I have built a beta version of Linchpin People’s SSIS Framework, now including much-requested reports. You can grab the updated copy here. I appreciate any feedback you care to share. :{>

Earlier today, Microsoft announced SQL Server 2012 has been released to manufacturing! General availability of the cool, new database platform is scheduled for 1 April 2012. I’ve been working with pre-release versions of the software while writing SSIS Design Patterns. While I have focused mostly on new Integration Services features, I have been most impressed …
Continue reading Microsoft Announces SQL Server 2012 RTM!

Warning: I am about to express an opinion.* Introducing disruptive database technology is the perfect trap for database administrators. <…freak out here…> <… done? Good. Let’s continue…> Way back in 2007 – when Adam first emailed me about writing at SQLBlog – I wrote a post that asked “Which ‘flavor’ DBA are you?” I had …
Continue reading The Perfect Trap

CozyRoc announces the release of the SSIS+ 1.6 Beta 1 Library. I installed this on my SQL Server 2012 RC virtual machine and have started testing. So far, I like it! :{>

I am excited to co-present A Day of SSIS at the Atlanta SQL Saturday #111 13 Apr 2012! The SQL Saturday event will be Saturday 14 Apr 2012, but the precons (there are three!) will be Friday 13 Apr 2012. Matt Masson (Blog | @mattmasson) is co-presenting. If you have never had the opportunity to …
Continue reading Co-Presenting A Day of SSIS with Matt Masson at SQL Saturday #111 in Atlanta 13 Apr 2012!

I am honored to present “Building Your First SSIS Package in SQL Server 2012” at the NJ SQL Server User Group Tuesday, 21 Feb 2012 starting at 6:00 PM! If you read this blog and will be in the area, please stop by and introduce yourself! I’m the fat guy with a fu. :{>

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 …
Continue reading From Zero To SSIS! London, 5-9 Mar 2012

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 …
Continue reading From Zero To SSIS! London, 5-9 Mar 2012

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: …
Continue reading SSIS Snack: Name Those Connections!

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