The Recording for Loading Medical Data with SSIS is Available

Kent Bradshaw and I had a blast delivering Loading Medical Data with SSIS earlier today! If you missed the webinar and, perhaps more importanly, coupon codes to save on upcoming Enterprise Data & Analytics Training. Enjoy the video! We demonstrated a handful of (free!) DILM Suite (Data Integration Lifecycle Management) utilities: Catalog Reports SSIS Catalog …
Continue reading The Recording for Loading Medical Data with SSIS is Available

Free Webinar – Enterprise SSIS Execution

Join Kent Bradshaw and me as we present (another) free Enterprise Data & Analytics webinar Tuesday, 23 Apr 2019 at 12:00 PM EDT: Enterprise SSIS Execution. Abstract SQL Server Integration Services (SSIS) is a powerful enterprise data integration tool that ships free with Microsoft SQL Server. Join Andy Leonard – Microsoft Data platform MVP, author, …
Continue reading Free Webinar – Enterprise SSIS Execution

Regarding SSIS Frameworks, Part 1 – Execution

Why Use a Framework? The first answer is, “Maybe you don’t need or want to use a framework.” If your enterprise data integration consists of a small number of SSIS packages, a framework could be an extra layer of hassle metadata management for you that, frankly, you can live without. We will unpack this in …
Continue reading Regarding SSIS Frameworks, Part 1 – Execution

The Next Developing SSIS Data Flows with Labs Course Delivery is 17-18 Jun 2019

I’m excited to announce the next delivery of Developing SSIS Data Flows with Labs will be 17-18 Jun 2019! This two-day course takes a hands-on approach to introduce SSIS Data Flows with a combination of lecture and labs. About Developing SSIS Data Flows with Labs Data integration is the foundation of data science, machine learning, artificial …
Continue reading The Next Developing SSIS Data Flows with Labs Course Delivery is 17-18 Jun 2019

The Next Mastering the SSIS Catalog Course Delivery is 11 Jun 2019

I’m excited to announce the next delivery of Mastering the SSIS Catalog will be the morning of 11 Jun 2019! This half-day course brings you up to speed on the SSIS Catalog quickly and efficiently, and we have great fun along the way. About Mastering the SSIS Catalog Data integration is the foundation of data …
Continue reading The Next Mastering the SSIS Catalog Course Delivery is 11 Jun 2019

“That was Worth the Price of the Course!”

I’m delivering Expert SSIS today. I hear the statement that is the title of this post each and every time I deliver this training. The advice and demonstrations are all based on experience… hard-fought-and-won experience. Sign up for the next delivery. Two days, live, online – with me! Join me and level-up your SSIS! Register …
Continue reading “That was Worth the Price of the Course!”

SSIS Design Pattern: Use Script Tasks for ETL Instrumentation

I consider scripting in SQL Server Integration Services (SSIS) my data integration “get out of jail free” card. Why? If I cannot find a way to accomplish some requirement using SSIS’s built-in objects – tasks, containers, Data Flow components, etc. – I can usually write .Net code to fulfill the requirement. As stated in the …
Continue reading SSIS Design Pattern: Use Script Tasks for ETL Instrumentation

Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!

I am honored to announce I will be delivering Intelligent Data Integration through SSIS – a day-long SQL Saturday 841 – Dallas pre-conference session 31 May 2019! Description: What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data …
Continue reading Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!