I coauthored my 15th book Together with Christian Cote (lead author) and Matija Lah (coauthor) we publishes SQL Server 2017 Integration Services Cookbook. Of course, it is kind of early to say this is a definitive guide to SSIS 2017. More accurate name would be SSIS 2016 / 2017 Cookbook. Besides detailed guidelines how to use the 2016 version, you ...

This blog has moved! You can find this content at the following new location: http://andyleonard.blog/2017/07/27/schedule-an-ssis-application-with-ssis-framework-community-edition/

On April 15, 2017 I’ll be speaking at SQL Saturday in Redmond, WA. I’ve settled down after the recent changes, so it’s time to start to be an active part of the Microsoft Data Platform (former SQL Server) community again. I’ll be talking about monitoring SQL Server Integration Services and the amazing support for JSON in SQL Server 2016: SSIS ...

When I am not designing a database, I am usually loading it with data (a good percentage of my time is spent designing data warehouse structures, along with relational ones. Using SSIS is often a challenge, for many reasons, but the most challenging for me is the expression language. Using a Derived Column Transformation, a common task is to turn ...

This blog has moved! You can find this content at the following new location: http://andyleonard.blog/2016/02/07/microsoft-is-listening/

Update. The challenge set below has been responded to by Scott Currie who also happens to be the inventor of BIML. He has made his work  available at https://github.com/bimlscript/BETDPI In February 2004 I joined a company called Conchango and had the pleasure of working with some very very smart people (Mick Horne, Dan ...

I’ve moved my SSISDB scripts from Gist to GitHub where I can maintain them more comfortably. So far, I’ve published 6 scripts: ssis-execution-status: Latest executed packages ssis-execution-breakdown: Execution breakdown for a specific execution ssis-execution-dataflow-info: Data Flow information for a specific execution ...

Lately I’ve been using Azure Automation which is a service on Azure for running Powershell Workflow scripts, as such as I’ve diving deep into Powershell Workflow. What’s Powershell Workflow? I’m glad you asked: A workflow is a sequence of programmed, connected steps that perform long-running tasks or require the coordination of multiple steps ...

Yesterday I’ve released the latest SSIS Dashboard update. There quite a lot of new features included that I found to very useful when you have a server full of packages and logs. Here the complete list: Highlighted the feature I think worth the most: Updated Morris.js to v 0.5.1 Updated MetisMenu to v 1.1.1 Added information on ...

In the last days I’ve worked again on the SQL Server Integration Service Dashboard and I did some updates: Beta Added support for "*" wildcard in project names. Now you can filter a specific project name using an url like: http://<yourserver>/project/MyPro* Added initial support for Package Execution History. Just ...