SSIS Catalog Browser v0.9.9.0 is Available

I am excited to announce the latest release of SSIS Catalog Browser! SSIS Catalog Browser version 0.9.9.0 is free and features enhanced Folder, Project, and Package Properties, surfacing Description, Validation Status, and Last Validation Time properties: These same properties – Description, Validation Status, and Last Validation Time – are now also included in the scripting …
Continue reading SSIS Catalog Browser v0.9.9.0 is Available

SSIS Script Error: Cannot Load Script for Execution

If I had a nickel for every time I’ve encountered “Cannot load script for execution,” I’d have a lot of nickels. In this short (7:24) video, I demonstrate the issue and my fix: My Fix For me, the fix is almost always setting the SSIS project’s TargetServerVersion property to the proper version: “Andy, How Did …
Continue reading SSIS Script Error: Cannot Load Script for Execution

Rest In Peace, Brian Moran (Updated)

Update: Emily, Brian’s daughter, has updated Brian’s Facebook page with information about a memorial service 31 Jul.  It grieves me to share that my friend and brother, Brian Moran, passed away late last week. Brian was a gifted technologist and businessman. He built a career and reputation as a SQL Server expert through articles in …
Continue reading Rest In Peace, Brian Moran (Updated)

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