Announcing SSIS Framework Manager, v1

I am excited to announce the release of SSIS Framework Manager! Alongside SSIS Framework Community Edition – our free and open source execution framework, SSIS Framework Editions – a comparison of Community, Standard, Professional, and Enterprise editions, and SSIS Framework Browser – our free utility that grants read-only access to our SSIS Frameworks; SSIS Framework Manager …
Continue reading Announcing SSIS Framework Manager, v1

New DataDriven Episode – Chris Wexler on Using AI to Protect the Vulnerable

Content Warning: In this show, Frank and Andy interview Chris Wexler of Krunam.co to discuss using AI to classify images containing child sexual content. The work is important. The discussion is not suitable for all ears. Please consider your surroundings before listening. Frank and I recommend headphones for consuming this content. When we record shows, …
Continue reading New DataDriven Episode – Chris Wexler on Using AI to Protect the Vulnerable

26 May 2021 SSIS Framework Updates Video

Earlier today (26 May 2021) I took the opportunity to share another SSIS Framework Manager update. In a live stream Monday (24 May 2021), one of my Application Package Parameter scripts failed. I didn’t have time until earlier today to debug the script. What was the root cause of the failure? Bad data. Apparently, I’d …
Continue reading 26 May 2021 SSIS Framework Updates Video

SSIS Framework Manager Updated

I am so excited to announce scripting in SSIS Framework Manager – a new component of the Data Integration Lifecycle Management Suite – is code complete! My first-pass testing worked really well, so I decided to go live on LinkedIn Live and demonstrate it. I practiced a few test-walk-throughs and it all worked. As is …
Continue reading SSIS Framework Manager Updated

T-SQL Tuesday #138 – Managing Technology Changes – Wrap-Up

This month’s T-SQL Tuesday attracted some great responses! Thank you to everyone who participated! Reitse Eskens checked in with T-SQL Tuesday #138 – Keeping up with change. For whatever reason, his pingback did not make it to my blog. I apologize for the oversight, Reitse. Thank you for reaching out so I could get this corrected. …
Continue reading T-SQL Tuesday #138 – Managing Technology Changes – Wrap-Up

T-SQL Tuesday 138: Managing Technology Changes

I’m honored to host T-SQL Tuesday for May 2021. One point I make (repeatedly) in my latest book – titled Building Custom Tasks for SQL Server Integration Services – is “software changes.” In fact, software changed on me between the completion of editing and the release of the book! I wrote about the changes in a …
Continue reading T-SQL Tuesday 138: Managing Technology Changes

New SSIS Extension v3.13.1 for Visual Studio 2019

On 12 Apr 2021, the Microsoft SSIS Team released version 3.13.1 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning. On 24 Apr 2021, the Integration Services extension was updated. The page displays this information …
Continue reading New SSIS Extension v3.13.1 for Visual Studio 2019

SSIS Framework Manager Property Overrides Video

I’m adding a GUI to DILM Suite called SSIS Framework Manager. If you read that name and guessed the GUI manages the SSIS Framework metadata, you are correct! I’ve been streaming as I’ve coded along on the project. I reached a pretty good functionality place earlier this week. Since then, I’ve been testing. I thought …
Continue reading SSIS Framework Manager Property Overrides Video