Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sean_B
Posting Yak Master
111 Posts |
 Posted - 2007-07-04 : 06:53:31
|
| Hi,I've a whole suite of files that I want to load, many of which can be loaded concurrently and some which can only be loaded once other files have already been loaded.I'm using a seperate Stored Procedure (sp) per file with bulk insert and I'm calling these bulk insert sp's from a controlling sp, what I'd like to do is call several load processes simultaneously from the control sp, and wait till they have all completed before moving on to the next set of files.I'm about to start investigating using osql to do this, but I would be grateful for any suggestions, useful articles etc that anyone can offer.ThanksSean |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Sean_B
Posting Yak Master
111 Posts |
Posted - 2007-07-04 : 08:09:30
|
| Thanks for the advice I will look at this.Sean |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-04 : 12:27:33
|
also you can do asynchronous stuff in 2005 using service broker. another possibility is you could create a agent job. calling msdb.dbo.sp_start_job returns immediately so it's another way to do work asynchronously.
elsasoft.org |
|
|
|
|
|
|
Calling stored procs asynchronousl y