Thank you for your response Jeff.

I do apologize for my post before, I have been under quite a lot of stress and am severely sleep deprived.

Also, in 9 years of doing this, SSIS (or previously DTS) has always been used to extract data from a source system, so I guess hearing "don't use SSIS" seems a bit odd to me.

I will however give OPENQUERY some testing and see where I get with this.

I do not know however, how to execute concurrent jobs, so if you don't mind, could you please elaborate on that one 🙂