Zdenek,

I have found the Openquery method to be quicker.  The only downside is that you pass the 'query' part as a string so therfore have to be careful with quotes.

Cheers Brian,

I did as you suggested and looked at the sp_OA procedures.  In the BOL examples there was exactly what I was looking for using the 'connect' method.  However when...

Thanks AJ, but I've tried that and you can't trap the error as it is a level 16 and quits the loop if it finds a server that's not available.

You could create a package that has the seperate stored procedures as a seperate SQL task.  The default for concurrency is 4, but you can change it.

It is possible to...

Thanks Russel.

Have a look at the DTS package at the link below:

http://www.sqldts.com/default.aspx?t=6&s=103&i=246&p=1&a=0

It shows how to loop around a package reading files from a directory, whilst not quite want you are trying...