Have you tried using IN in the drillthrough report and passing them through using the Join command?

Syntax is =Join(Parameters!<yourParameterName>.Value, ",").

Lowell (11/8/2011)

---

I'm not an SSIS guy, but i do know that the you can map a network drive with the NET USE command allows you to specidy a domain...

Hi...

John Mitchell-245523 (11/8/2011)

---

You should be able to do everything with UNCs. You haven't said what operations you'll be carrying out on the folders, so I'm just guessing, but if...

I know, I said it was stupid... I'm not even sure why this job landed in my lap!

I'll give that a go and post back the outcome. Thanks for your...

Thanks for your reply. I wanted to use a mapped drive but I've been given orders from on high that I'm not allowed to map any drives to the servers....

Use a merge join or a lookup on the sql table. With merge join, set your excel recordset as the left input and use a conditional split where the joined...

You could use an execute sql task to select distinct values from that column, write the results to an object variable and loop over that in your container.