My latest article in the Stairway to Integration Services, Flexible Source Locations - Level 16 of the Stairway to Integration Services is now live at SQL Server Central! Enjoy! :{>

An Overview of SSIS Parameters - Level 15 of the Stairway to Integration Services is now live at SQL Server Central! Enjoy! :{>

SQL Saturday #277 is going to be held 22 Mar 2014 in Richmond Virginia! There will be three day-long pre-conference sessions on Friday 21 Mar: Performance Tuning and Troubleshooting Like a Pro by Robert L. Davis (@sqlsoldier) Murder They Wrote by Wayne Sheffield (@DBAWayne) and Jason Brimhall (@sqlrnnr) SSIS Design Patterns by me ...

I am honored to present “I See A Control Flow. Now What?” at SQL Saturday Nashville on Saturday 18 Jan 2014! There are a bunch of really cool presentation scheduled, including a few Linchpins! I hope to see you there! Register here. :{>

SQLPASS TV channel has been published the session Automate Your ETL Infrastructure with SSIS and PowerShell that Allen White (@SQLRunr) has done during the PASS Summit 2013.  Abstract Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single ...

Let me point out the upcoming live events scheduled for December 2013 organized by PASS Business Intelligence Virtual Chapter.   Create and Load a Staging Environment from Scratch in an Hour with Biml Date: Thursday 12 December Noon PST / 3 PM EST / 8 PM GMTSpeaker: Scott CurrieURL: ...

A long long long time ago (in 2006 in fact) I published a blog post entitled Suggested Best Practises and naming conventions in which I suggested a bunch of acronyms that folks could use to prefix object names in their SSIS packages, thus allowing easier identification of those objects in log records, here is a sample of some of those suggestions: ...

Since December 2010 I have been maintaining a suite of reports that can be used atop the SSIS Catalog in SSIS 2012, I called it the “SSIS Reporting Pack”. While building those reports I realised that there was also a need to make it easier to issue common but ad-hoc queries against the SSIS Catalog and that realisation gave rise to a stored ...

Development of sp_ssiscatalog continues apace with a new release today (4th July 2013). In this release I have enabled a new action called ‘exec_failed’ which can be simply described as “Show me the most recent failed execution”. The syntax is very simple: exec sp_ssiscatalog @action = 'exec_failed' exec sp_ssiscatalog @a = ...

An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services is up and available at SQL Server Central! :{>