I've created two simple, yet very useful, script to extract some useful data to quickly monitor SSIS packages execution in SQL Server 2012 and after.get-ssis-execution-status  get-ssis-data-pumped-rows  I've started to use gist since it comes very handy, for this ''quick'n'dirty'' scripts and snippets, and you can ...

The SSIS Data Pump - Level 2 of the Stairway to Integration Services has been republished at SQL Server Central! You can find additional articles in the Stairway to Integration Services series here. Enjoy! :{>

I am honored to present Using Biml as an SSIS Design Patterns Engine to Lynchburg SQL Server Users Group Thursday, 26 Jun! Abstract  Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility ...

Deployment and Execution – Step 18 of the Stairway to Integration Services is live at SQLServerCentral.com! Enjoy! :{> 

I am still working apace on updates to my open source project SSISReportingPack, specifically I am working on improvements to usp_ssiscatalog which is a stored procedure that eases the querying and exploration of the data in the SSIS Catalog. In this blog post I want to share a titbit of information about usp_ssiscatalog, that all the actions ...

I am honored to participate in the Reston SQL Server 2014 Launch Update event – a half-day event held 16 May 2014 at the Microsoft Reston Office. You can learn more and register here. Art Rask will kick-off the event with an overview of new features of SQL Server 2014, including: Integrated In-memory technology AlwaysOn HA / DR for ...

On 31st March 2014 I released version 1.2.0.0 of SSIS Reporting Pack, my open source project that aims to enhance the SSIS Catalog that was introduced in SSIS 2012. This is a big release because it includes an entirely new feature  -the Restart Framework. Introduction The Restart Framework exists to cater for a deficiency within SSIS, ...

I am honored to present Using Biml as an SSIS Design Patterns Engine Monday 24 Mar 2014 at the Northern Virginia SQL Server User Group (NoVaSQL)! I hope to see you there. Details… :{>

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! :{>