Category:Uncategorized

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

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

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

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!

The launch of SSIS Catalog Compare is approaching. If you purchase the beta (or preview) version before the v1.0 product launch for $95 USD, you will enjoy lifetime updates of the product and no yearly maintenance fees for support, updates, and upgrades. If you wait, you will have to pay more for the product and …
Continue reading Updates to SSIS Catalog Compare (Preview)

You can find the recordings for Biml Academy 2 at the links below: Cathrine Wilhelmsen [Blog | @cathrinew]: Biml Academy 2 – Lesson 5 – Importing Data with Biml  Andy Leonard [@AndyLeonard]: Biml Academy 2 – Lesson 6 – Staging Data with Biml Andy Leonard [@AndyLeonard]: Biml Academy 2 – Lesson 7 – Metadata-Driven Staging …
Continue reading Biml Academy 2 Webinar Recordings are Available!

The recording for the Enterprise Data & Analytics webinar “Loading Medical Data to the Cloud” is now available (registration required). Enjoy! :{> Related Training: IESSIS2: Immersion Event on Advanced SQL Server Integration Services Related Articles: Stairway to Integration Services SSIS 2016 Administration: Create the SSIS Catalog SQL Server 2016 Developer Edition is Free Converting an …
Continue reading The Recording for Loading Medical Data to the Cloud is Available!

The recording for Biml Academy 2 – Lesson 5 – Importing Data with Biml by Cathrine Wilhelmsen [Blog | @cathrinew] is now available! Cathrine did an outstanding job walking through several methods for importing database schemas using Biml. It’s worth a view (registration required). :{>

In May 2015 I wrote 700 – a post marking my 700th blog post here at SqlBlog.com. Last month I wrote Nine Years about another milestone here. Well, here we are in August 2016 and I’ve reached 800 posts! It’s an honor and privilege to write here. Here’s to the next 100 posts! :{>

Have you ever tried to move some (or all) of the contents of one SSIS Catalog to another? Deploying an SSIS Project to a different SSIS Catalog is straightforward: Execute the ISPAC file, configure the new SSIS Catalog as the target, click a few times, and Boom; done. What about the rest of it? I …
Continue reading Data Integration Lifecycle Management (DILM) with SSIS Catalog Compare: SSIS Catalog Environments