Honored to Co-Present Intelligent Data Integration with SSIS and Azure Data Factory at Difinity 2020

I am honored to co-present a full-day post-conference workshop – Intelligent Data Integration with SSIS and Azure Data Factory – with Sandy Winarko, Principal Program Manager at Microsoft – Azure Data Governance, Cloud & Artificial Intelligence (AI), at Difinity 2020 in New Zealand! Details Full Day Workshop Level: 300 Post-Conference: 20th of Feb 2020 This …
Continue reading Honored to Co-Present Intelligent Data Integration with SSIS and Azure Data Factory at Difinity 2020

“It’s 10 July 2019 and We Still Have SSIS 2008 in Production…”

I am writing this post 10 Jul 2019. Yesterday, support ended for SQL Server 2008 and 2008 R2. Many are still running SQL Server 2008 and 2008 R2 in production, and many are using SSIS 2008 and 2008 R2 in production as well. If you are reading this post and thinking or saying, “Yep. He’s …
Continue reading “It’s 10 July 2019 and We Still Have SSIS 2008 in Production…”

How To: Execute Azure-SSIS Packages From Azure Files

UPDATE: View the recording of the free webinar titled Execute Azure-SSIS from Azure Files. Enjoy! :{> Join me Tuesday, 2 Jul 2019 at 12:00 PM EDT for a free webinar titled Execute Azure-SSIS Packages from Azure Files! An Updated Azure-SSIS Integration Runtime I confess: I have been waiting for this feature since I first learned …
Continue reading How To: Execute Azure-SSIS Packages From Azure Files

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

Free Webinar: Designing a Basic SSIS Execution Framework

Join me at 12:00 PM EDT 27 Jun 2019 for Designing a Basic SSIS Execution Framework – another free webinar from Enterprise Data & Analytics! Abstract Join Microsoft Data Platform MVP and author Andy Leonard for 60 minutes packed with demos of how to design a basic SSIS Execution Framework to centralize and simplify SSIS …
Continue reading Free Webinar: Designing a Basic SSIS Execution Framework

SSIS in SSMS Version 18: Try SSIS in Azure Data Factory

There’s a new option when you right-click the Integration Services Catalogs node in SSMS v18: “Try SSIS in Azure Data Factory”: Clicking the “Try SSIS in Azure Data Factory” option in SSMS v18 opens the (new) Integration Runtime Creation Wizard (ISIRCreationWizard.exe, which is found in the <installation drive>:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn directory): …
Continue reading SSIS in SSMS Version 18: Try SSIS in Azure Data Factory

SSIS in SSMS Version 18

Version 18 of SQL Server Management Studio (SSMS) has been out for a few weeks now, but I just now had the opportunity to install it and tinker. There are a lot of new features! Here’s a list of SSIS-related features: Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that are …
Continue reading SSIS in SSMS Version 18

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

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