Thank you Gianluca,

Very clever!

I just tweaked it a tiny bit, as given an order, I want the 3 orders that preceded it (didn't word this too well in my OP)

So,...

I now have the xml file reading and populating a variable User::ConString

Are you able to offer any more advice on setting the base connection string in the data flow. Done...

Thanks, always good to hear to your not the only one doing something 🙂

I am using SSIS, going through an upgrade at the moment so all our production databases are...