Hi Kenneth,

I've tried the option of a foreach loop both with dataflows in the foreach loop and also with a second package however always seem to encounter the problem that it only queries the first result from the table (connection string stored here).

I've added a message box and can see the connection text changing however the actual connection doesn't change.

Am I missing something obvious?

Thanks,

Adam