SQL Server Data Automation through Frameworks Book Available for Pre-Order

Although the cover image needs an update, my and Kent Bradshaw’s next book – titled “SQL Server Data Automation through Frameworks: Building Metadata-driven Frameworks with T-SQL, SSIS, and Azure Data Factory” is available for pre-order!

Announcing SSIS Data Flows and Administration Live, Online, Training Courses

I’m excited to announce fresh deliveries of two courses: 08-09 Apr 2020: SSIS Administration 13-14 Apr 2020: SSIS Data Flows Essentially, these courses are the first and second half of From Zero To SSIS. As I type (14 Mar 2020), both courses are on sale! Register for SSIS Data Flows or SSIS Administration today!These courses …
Continue reading Announcing SSIS Data Flows and Administration Live, Online, Training Courses

Free Webinar: Execute SSIS Packages in Azure-SSIS from Visual Studio

Join me 15 Jul 2019 at 12:00 PM EDT for another free Enterprise Data & Analytics webinar titled Execute SSIS Packages in Azure-SSIS from Visual Studio! Abstract Join Microsoft Data Platform MVP Andy Leonard for this free webinar to learn more about the Visual Studio Extension for Integration Services 3.1, which allows SSIS developers to …
Continue reading Free Webinar: Execute SSIS Packages in Azure-SSIS from Visual Studio

The Recording for Designing a Basic SSIS Execution Framework

As will sometimes happen when one chooses to type in demos, things went awry in the last demo. I choose to type in demos because I don’t want to create the false impression that SSIS Just Works the first time, every time. After the webinar ended I spent some time troubleshooting. The issue appears related …
Continue reading The Recording for Designing a Basic SSIS Execution Framework

The Recording of Build and Load a Staging Database with Biml

The recording of Enterprise Data & Analytics’ free webinar titled Build and Load a Staging Database with Biml is available! Get the Code! Download the SSIS solution files here: Load AdventureWorks2017_Stage – version 0 Load AdventureWorks2017_Stage – version 1 Load WideWorldImporters Want More? Learn more from Andy Leonard and the professionals at Enterprise Data & …
Continue reading The Recording of Build and Load a Staging Database with Biml

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