Got it. thanks!

@SSC Guru:

Okay, so ... i had a feeling it was something stupidly simple on my part, and apparently even more simple than I'd imagined.

I must have just been missing semicolons...

I blame a change in employment, corporate email addresses, and resulting having to open 1 new SSC account (just by virtue of having lost the old ones, nothing nefarious!) ::

I...

Wow.  I shake my head in admiration.  Not sure how many people have tapped into this variable-setting behavior, since a few google searches on the pro's of using Select to...

Thanks, I was looking into for xml as well as string_agg but ditched for xml path because i couldn't figure out how to make it work with returning "just one"...

• This reply was modified 5 years, 2 months ago by  ipisors 92539.

After a few hours, I was worried that no one knew the answer to this - and that it might be an obscure and/or undocumented problem.  In case you are...

• This reply was modified 5 years, 2 months ago by  ipisors 92539.

But the way I had it without a throw, and with a try/catch block...wouldn't necessarily be reliable to cause a component failure in SSIS?  That's what I meant / want...

ok thanks, that's a good option to know about, I hadn't mentally put that together as an option.

ty

I should also say that my OLE DB connection's actual name is ... well, I left it the way it defaulted to, which was:  server.database    
..Is that OK?  

(Note - my connection manager pictured below)

Thank you.
I currently get an SSIS error (pasted below), immediately after my Msgbox raises (and prior to the second Msgbox in the below code)
ERROR:
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[]...