The Recording for Enterprise SSIS Execution is Available

Kent Bradshaw and I had a blast delivering more free training from Enterprise Data & Analytics today – this time it was all about Enterprise SSIS Execution. If you were unable to attend, please enjoy the recording here: There’s a coupon code near the end of the recording that will save you money on Enterprise …
Continue reading The Recording for Enterprise SSIS Execution is Available

HowTo: Install SSIS Framework Community Edition

SSIS Framework Comunity Edition is available from DILM Suite (Data Integration Lifecycle Management Suite). SSIS Framework CE is not only free, it is open source. To install SSIS Framework Community Edition, visit DILM Suite and click SSIS Framework Community Edition: When the SSIS Framework Community Edition page opens, click the first link: This link will …
Continue reading HowTo: Install SSIS Framework Community Edition

Staging Data Temporarily in an SSIS Data Flow

My friend Slava Murygin (@SlavaSQL) recently asked a question on Twitter: Populated query results into an object variable sucessfully used it in a data flow task, but can’t use it second time. Is there an easy way around? Tim Mitchell (Blog | @Tim_Mitchell | Tim’s post: Temp Tables in SSIS) and I engaged. You can …
Continue reading Staging Data Temporarily in an SSIS Data Flow

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

Free Webinar: Loading Medical Data with SSIS

Join Kent Bradshaw – Database Administrator, Developer, and Data Scientist – and me, Andy Leonard – Microsoft Data platform MVP, author, blogger, and Chief Data Engineer at Enterprise Data & Analytics as we present Loading Medical Data with SSIS at 12:00 PM EDT 17 Apr 2019. Join this webinar and learn: An SSIS design pattern …
Continue reading Free Webinar: Loading Medical Data with SSIS

“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