Jeff, you are truly amazing and awesome! Thank you so much for the great help!

As a follow up question: The table2 could have completely different structure with a lot more...

BTW, I am using the service account for Data Source which reports are pointing to.

Thanks! 🙂

Thank you all! Looks like the easiest way is not to define data set using stored procedure, but to define the query directly in the report so I could use...

Thanks, Sean. In the example, the parameter is used as :

soh.SalesPersonID IN (@BusinessPersonID)

Since I am using the stored procedure, how do I use (@BusinessPersonID) in my exec proc...

Thanks. It comes from SSRS report drop down selection, I don't think i need to split strings here.

Anyone from SSRS would give me a hint?

Thank you all!

The subquery is a great and simple approach!

Thanks!

I figured that I could also use conditional split to get the values.

However, I have different problems now:

1) I am looping through the excel files and then sheets to get...

Any input?

Thanks!

Oh, no, i lied.

Just checked again, you were indeed right!

Can't believe that I made that mistake. I thought I checked.

Thanks!!!

I just have one RecCount Variable and I had set it to be global to the package level and initialized to 0.

Got it, thanks!

Great, thanks!

Paul, Thanks a lot for your script! I'd like to use that to get my sub-directory names and then use Foreach container to loop through.

Would you please elaborate the C#...

I understand how to get files using the "Foreach file Enumerator".

My question here is "I'd like to get the return of list of those date-coded subdirectories, i.e.

20091101_12

20091102_03"

How...