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

andyleonard.blog

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

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.