My friend, Sandy Winarko, recently published a fantastic summary of the efforts of the Microsoft SSIS Team to mitigate friction for enterprises seeking to lift and shift SSIS workloads to Azure. In my humble opinion, their work is outstanding. Looking In From the Outside As we say in Farmville Virginia, “Data integration and I go …
Continue reading SSIS and the Future – December 2020 Edition
Category:SSIS
SSIS 2019 Extension v3.11 Now Available
The Microsoft SSIS Team sent SSIS developers an early Christmas present this year: a new SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11 (Current Version): Release Date: December 23th, 2020 Build Version: 15.0.2000.149 Tested against Visual Studio 2019 16.8 Whats’ new: Make creating SSISDB optional in IR Creation Wizard. …
Continue reading SSIS 2019 Extension v3.11 Now Available
Stage Updates and Inserts for SSIS Data Flow Performance
A few days ago, I streamed SSIS Data Flow Performance, which you can view below (from LinkedIn) or by clicking the link to the YouTube recording: I share similar SSIS Design Patterns in my Expert SSIS course. I next deliver Expert SSIS 14-15 Dec 2020. Also, Expert SSIS is on sale for 50% off as part of my Cyber Monday Sale at the …
Continue reading Stage Updates and Inserts for SSIS Data Flow Performance
Foreword – Building Custom Tasks for SSIS 2nd Edition
I’m excited to announce Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond 2nd Edition is available for pre-order at Amazon! I spent more time on this book and the demo task – the Execute Catalog Package Task – than any other book I’ve authored or …
Continue reading Foreword – Building Custom Tasks for SSIS 2nd Edition
Using Delimiters with HashBytes for Change Detection
A week or so back, I streamed 100% Efficient Data Integration, which you can view below (from LinkedIn) or by clicking the link to the YouTube recording: I share this SSIS Design Pattern in my Expert SSIS course. I next deliver Expert SSIS 14-15 Dec 2020. Also, Expert SSIS is on sale for 50% off …
Continue reading Using Delimiters with HashBytes for Change Detection
AWS and SSIS
Brent Ozar, my friend and brother from another mother, shared an interesting link on LinkedIn. The article Brent linked is titled Amazon RDS for SQL Server now supports the Business Intelligence Suite on SQL Server 2019. I find the topic interesting for a number of reasons. I’m interested in helping enterprises lift and shift on-premises …
Continue reading AWS and SSIS
Executing Synchronously from DtExec
Five years ago, I wrote a blog post titled The SYNCHRONIZED SSIS Execution Parameter. Recently, I received a comment with a question: One way to execute SSIS packages stored in the SSIS Catalog from SQL Agent is to use the CmdExec job step type. As with all command-level access, please research security implications. Use a …
Continue reading Executing Synchronously from DtExec
Environment Properties Node for Catalog Browser
I’ve been working on SSIS Catalog Compare and its free counterpart SSIS Catalog Browser. Earlier I added Folder and Project Properties nodes, more recently I added Environment Properties: Environments are… tricksy. Why? Because of broken references. I can hear some of you thinking,… “What’s a broken reference, Andy?” That’s an excellent question – I’m glad you …
Continue reading Environment Properties Node for Catalog Browser
Folder and Project Properties Nodes for Catalog Browser
I’m happy to announce the addition of Folder Properties and Project Properties nodes to SSIS Catalog Browser, a free utility from DILM Suite that surfaces a unified view of the SSIS Catalog: As ever, the same functionality is available in SSIS Catalog Compare. Contact Enterprise Data & Analytics to learn more. Enjoy! :{> Need Help? …
Continue reading Folder and Project Properties Nodes for Catalog Browser
My Black Friday 2020 Sale is On!
Do you read my blog? Would you like to save money on Azure Data Factory and SSIS training (from me!) for a full year? For a limited time, you can save $4,000 (67%) on my Live ADF and SSIS Class Season Pass! Visit Enterprise Data & Analytics Training to view upcoming public course deliveries and …
Continue reading My Black Friday 2020 Sale is On!