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-us/ado270/htm/mdmthupdatebatch.asp?frame=true

http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthupdatebatchx.asp?frame=true

 

[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