Yes I've thought of that, but I'm simply not good at TSQL. I'll most
definately be using stored procedures to break the process down in chunks,
and have some reuse available to me, but there is a lot of intense
calculations with the results (100,000's of records) being stored in several
tables, probably not even a temp tables, because this data needs to be
highly available after the process is done.
Hopefully I'll be able to keep the calls to the database low, as well as the
amount of data being transfered between SQL Server and the Windows service.
Eventually I want this to be running on its own dedicated server perhaps.
Some processes may run on the hour.
I guess I'm asking here to make sure I'm considering all the options.
-Max
"John Oakes" <jo**@nospam.networkproductions.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Why don't you just create a DTS package to do this? I know you want to
keep it in VS.NET environment, but there are a lot of advantages to just using
DTS.
-John Oakes