February 16, 2010 at 3:37 pm
I have a situation where I am inserting records into several tables from other servers. I have scripted it all out, but I would like to be able to execute a few of these in different connections/SPIDs.
In a DTS package I can set up multiple connections, and the imports will run simultaneously, what I would like to do is use T-SQL to do the same sort of thing. I have not had much luck searching for an answer, which could be not knowing the right question. Searching for Parellel for example sends me on the parellism track.
Can any one point me in the right direction on this, or tell me if it is even possible?
Thanks alot!
February 16, 2010 at 3:59 pm
I am sure someone will correct me if I am wrong, but I don't think this is possible from tsql. The reason it is possible from a DTS package, is that the DTS package is able to open more than one connection.
The only other way I could think to do it would be to setup a service broker queue with max queue readers of how many spids you want to have open. Based upon the data that is passed in, execute the correct section of code. Kinda a hack, but might do what you are looking for.
Fraggle.
March 24, 2010 at 8:35 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply