need more ideas on importing delimited text files

[TJS]

I need to import delimited text files (several thousand records each) on a
shared hosted website:

currently building insert statements from ASP.net file but this is pig slow
and burns way too much cpu.

Constraints:
- webhost locked out bulk insert ( says it is a security risk )
- building insert queries takes too much cpu
- no admin privileges available
- DTS not allowed on server ( says it is a security risk )
- cannot change settings on things like registry
- cannot use any command line stuff for bcp

There must be another way to do this.

what else is an option??

[oj]

No bulkload?! So typical of ISP! :)

The next best option is to perform updatebatch. See if this helps.

http://msdn.microsoft.com/library/en...asp?frame=true

http://msdn.microsoft.com/library/en...asp?frame=true
--
-oj
http://www.rac4sql.net
"TJS" <no****@here.com> wrote in message
news:e6**************@TK2MSFTNGP09.phx.gbl...

I need to import delimited text files (several thousand records each) on a
shared hosted website:

currently building insert statements from ASP.net file but this is pig slow and burns way too much cpu.

Constraints:
- webhost locked out bulk insert ( says it is a security risk )
- building insert queries takes too much cpu
- no admin privileges available
- DTS not allowed on server ( says it is a security risk )
- cannot change settings on things like registry
- cannot use any command line stuff for bcp

There must be another way to do this.

what else is an option??

[Michael Pearson]

Maybe you could kick this stuff on a thread set to lowest priority. It's
going to Peg out the CPU, but since the priority is so low, other stuff will
still run ok (like ASP.net :) ).

You might also consider a new host.

Michael

"TJS" <no****@here.com> wrote in message
news:e6**************@TK2MSFTNGP09.phx.gbl...

I need to import delimited text files (several thousand records each) on a
shared hosted website:

currently building insert statements from ASP.net file but this is pig slow and burns way too much cpu.

Constraints:
- webhost locked out bulk insert ( says it is a security risk )
- building insert queries takes too much cpu
- no admin privileges available
- DTS not allowed on server ( says it is a security risk )
- cannot change settings on things like registry
- cannot use any command line stuff for bcp

There must be another way to do this.

what else is an option??

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.573 / Virus Database: 363 - Release Date: 1/28/2004