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 been generating duplicate Application Package Parameters for a while, and had not bothered to check until they threw a multiple-results-returned error. The error wasn’t wrong – there were a lot of records being returned for each parameter!

Today I walked through the same demo without error. w00t.

Enjoy the video!


Andy Leonard


Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS, and Biml guy. I was cloud before cloud was cool. :{>