2017 SQL Skills SSIS Immersion Events

I’m home after a day of travel that included waking up at quarter-til-early to catch a cab to SeaTac with Tim Mitchell [blog | @Tim_Mitchell], bumpy flights, and a two-hour drive back to Farmville. We had a fantastic time! Our students asked lots of interesting questions and Tim and I were, I believe, able to …
Continue reading 2017 SQL Skills SSIS Immersion Events

A New Version of SSDT is Available

Microsoft released an update to SQL Server Data Tools (SSDT) 2016 on 20 Sep 2016 – the tool used to design databases, SSIS, SSRS, and SSAS solutions. I can hear you thinking, “How do I get the update, Andy?” You can get version 14.0.60918.0 here. If you have the installer for SQL Server 2016 handy, you …
Continue reading A New Version of SSDT is Available

I Was Wrong (About the SSIS Catalog)

I apologize for misleading people who read my writings and have heard me speak on the topic of the SSIS Catalog. Here’s what I recently realized: The execution_id is different from the operation_id in the SSISDB database. In the past, I complained about the execution_id and operation_id being the same value and meaning different things. …
Continue reading I Was Wrong (About the SSIS Catalog)

I’m Presenting at SQL Saturday Charlotte (#560) Next Saturday!

I’m honored and all giggly with anticipation about presenting at SQL Saturday 560 in Charlotte next Saturday, 17 Sep 2016! I’m presenting Biml and SSIS Frameworks, and I hope to see many of you there. For the SSIS Frameworks part of my presentation, I’m using SSIS Framework Community Edition, a free and open source SSIS …
Continue reading I’m Presenting at SQL Saturday Charlotte (#560) Next Saturday!

The Basics of Biml – the Execute SQL Task

A couple years ago, I wrote a series of guest posts about the Basics of SSIS for my friend Pinal Dave’s [Blog | @pinaldave] popular blog, SQL Authority. In that series, I pointed out that I use only a handful of SSIS Control Flow tasks when designing SSIS packages. You can find the series here: …
Continue reading The Basics of Biml – the Execute SQL Task

The Basics of Biml – Populating the Biml Relational Hierarchy

In this post, I’m going to demonstrate how to build the objects Business Intelligence Markup Language (Biml) requires before creating anything – the Biml Relational Hierarchy. The Biml Relational Hierarchy provides the foundation for all relational interaction between packages, cubes, dimensions, facts, and T-SQL. It’s important to note that Biml is useful for generating SSIS …
Continue reading The Basics of Biml – Populating the Biml Relational Hierarchy

Announcing SSIS Catalog Compare v1.0

We’re proud to announce the release of SSIS Catalog Compare v1.0! SSIS Catalog Compare compares the contents of two SSIS Catalog instances, surfacing SSIS project-related configurations metadata in treeview controls. Data Integration Lifecycle Managers, DevOps personnel, and configuration and release managers can script configurations metadata for deployment to another SSIS Catalog instance. Users may also …
Continue reading Announcing SSIS Catalog Compare v1.0

Biml Academy 3 Will Be Held 7-11 Nov 2016

Enterprise Data & Analytics and Varigence are honored to announce Biml Academy 3 will be held 7-11 Nov 2016! Register today! Learn more about Biml Academy and view recordings from previous sessions at Biml.Academy! A great big "THANK YOU" to SQL Server Central for help spreading the word! :{> Learn More: Stairway to Biml Stairway …
Continue reading Biml Academy 3 Will Be Held 7-11 Nov 2016

Announcing the Biml Academy Website!

Enterprise Data & Analytics and Varigence are honored to announce a new website focused on Biml Academy! Visit Biml Academy to register for the next Biml Academy event or to view recordings of previous Biml Academy presentations: You can also follow Biml Academy on Twitter (@BimlAcademy)  and Facebook. A great big "THANK YOU" to SQL …
Continue reading Announcing the Biml Academy Website!