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

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