On occasion I have the privilege and honor of delivering a full-day precon titled Intelligent Data Integration: SSIS Design Patterns and Biml as part of SQL Saturday events. “Isn’t This The Same Presentation You Delivered Before, Andy?” Yes and no. It has the same title but… I’ve focused on Biml presentations for the past two years. Over the …
Continue reading Intelligent Data Integration, SSIS Design Patterns, and Biml
A Custom Biml Framework in Action!
Watch this short video (2:32) of a custom Biml Framework in action.
The Recording for Designing an SSIS Framework is Now Available
Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can view the webinar for free (although registration is required) here. In the webinar Kent and I discussed the following Data Integration Lifecycle Management Suite products: SSIS Framework Community Edition – free and open source Catalog Reports – …
Continue reading The Recording for Designing an SSIS Framework is Now Available
IESSIS1: Immersion Event on Learning SQL Server Integration Services – Chicago, 2-6 Oct 2017!
I am honored to once again deliver Immersion Event on Learning SQL Server Integration Services (IESSIS1) in Chicago with SQLSkills 2-6 Oct 2017! You can find additional details here. Click here to register! Here’s what I’ll be covering: Module 1: Introduction In the introduction we share information about the instructor, course flow, and content, and gather …
Continue reading IESSIS1: Immersion Event on Learning SQL Server Integration Services – Chicago, 2-6 Oct 2017!
The Recording for Biml in the Enterprise Data Integration Lifecycle is Available!
The recording for the webinar Biml in the Enterprise Data Integration Lifecycle is now available (registration required). The password for the meeting is BimlRocks. You may be reading this post and thinking, “But Andy, I don’t recall seeing anything about this webinar until just now.” That’s entirely possible. I advertised this webinar in advance, but only to members of the DILM Mailing …
Continue reading The Recording for Biml in the Enterprise Data Integration Lifecycle is Available!
New Data Driven Podcast: Buck Woody!
Frank and Andy laughed an awful lot in our latest Data Driven podcast. Why? They were speaking with Mr. Buck Woody!
What is the DILM Suite? 2. SSIS Catalog Compare
SSIS Catalog Compare is really two products: SSIS Catalog Compare (GUI – graphical user interface) and CatCompare (CLI – command-line interface). This post will focus on GUI functionality as it’s easier to demonstrate. SSIS Catalog Compare provides the following functionality to enterprise Data Integration Lifecycle Management (DILM): Compares the contents of two SSIS Catalog instances. …
Continue reading What is the DILM Suite? 2. SSIS Catalog Compare
What is the DILM Suite? 1. SSIS Framework Community Edition
Andy Leonard shares solutions for managing enterprise SSIS – the Data Integration Lifecycle Management (DILM) Suite.
Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
This post was originally shared on SQLBlog. You’re coding away with SSIS, happy as a clam, and it’s now time to deploy your hard work to an instance of the SSIS Catalog. If you’re in Visual Studio, you right-click the project name in Solution Explorer and click Deploy. If you’ve been given an ISPAC file, …
Continue reading Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
Why Automate?
This post was originally published at SQLBlog. Because, as Jen Underwood (jenunderwood.com | LinkedIn) states in the Data Driven podcast Jen Underwood on Data Visualization and Automating Data Science: The future of data science is automation. If automation is the future, how do we decide what to automate? We look for the long pole. What’s the long pole in data science? …
Continue reading Why Automate?