Inspired by the DBA tools (https://dbatools.io/) library for automating all things SQL Server DBEngine I created some Powershell Library functions to automate SSIS Build and Deployment. We use this on projects to move SSIS closer to the world of DevOps and that magic “10 deploys a day”. These Powershell functions work well when added to … Continue reading Automating SSIS Build and Deployment with Powershell
Category: SSIS
On of the best events in SSIS is “OnPipelineRowsSent” as this gives you performance data on how many rows are flowing through buffers and is great for performance analysis. Unfortunately I just found out the hard way that while it worked in SQL 2005 and 2012 it does not fully work in SQL 2008R2. Big … Continue reading OnPipelneRowsSent not logged in SQL 2008R2