Any way to import from multiple SharePoint sites in a loop?

Mar 21, 2013 at 11:00 AM

I've got a number of SharePoint sites, all with the same list definition inside; I'd like to use SSIS to consolidate the data from all those sites;

Importing multiple sharepoint sites

I'm struggling to see if you can vary the 'SiteUrl' property of the SharePoint List Source inside the ForEach loop. I would normally expect to see an 'Expressions' property and do something like "SiteUrl : @User::sharepointUrl" but there doesn't seem to be anything like that.

Any ideas?