Many thanks for the recommendation!

Many thanks for the response

The conditional split was exactly what was needed. I placed a rule/filter in the conditional split to only export rows that had a 9-digit social security number into the...

I figured this out, although I don't understand why this is the way it is.

I was going into the "View Code" option (this is from memory, but I believe that's...

Turns out u don't have to have Excel installed on the client machine, only the Microsoft Acess 2010 redistributable.

Oh I bet that's the deal. I just ran it in the immediate window and didn't wait to actually see what ended up being inserted into the email. I bet...

I must say, the Project Deployment Model as opposed to the Package Deployment Model seems overwhelming as far as the differences, the length of time it appears to take to...

Correct... using SSIS 2012. I'm familiar with SQL Server and have worked with it on/off for 15+ years, but this project is my first new stab at SSIS specifically.

I'll...

I can't thank you enough for your very clear communication on what I should need to do with respect to the eventual installation on my client's 64-bit SQL Server machine!...

I've finally figured this out after a bunch of trial and error.

My code's on my laptop at home so I don't have access to it right now, but I'll post...

None at all of the examples I am finding actually work once I implement and modify the code for my particular situation. It only seems to loop through the root...

Thanks for the info. Will post back here moving forward if I get stumped. Thanks again.

All is good. Thanks again for the collective direction on my question.

Thanks for the observations and recommendations.

The stored procedure snippet I posted is from an old VB6 application I developed many years ago. I'm in the process of rewriting the...

Many thanks for the info. I'll check this out and will try to implement / modify it as needed this eve.