Archives

How to Import Existing SSIS Packages into Biml With BimlExpress

I’m asked the same question almost every time I present on Biml. “How do I import my existing SSIS packages?” Well in this post, I’m going to show you how to do it with BimlExpress 2019 for free.

This post is part of a series, Short Cuts to Biml Mastery which shows you […]

Short Cuts to Biml Mastery

I’ve been giving Biml related presentations for many years and shared what I believe are the most efficient ways to learn it. It’s possible to get enough Biml knowledge to become productive in a number of weeks, assuming one has time to focus on it. However context switching, commonly referred to as multi-tasking, kills the […]

Interesting Integration Services (SSIS) Error and Solution.

While troubleshooting an existing 2008 R2 package the other day I received the following error.

Error HRESULT E_FAIL has been returned from a call to a COM component.

The error occurred when I was using breakpoints and watch windows to diagnose problems in the package. The breakpoint behavior was off because even when there wasn’t a […]