NO.....they are resumes and people vary the location of content.

Thanks

I played with the code and at least have got it to load 574 text resumes in one session 🙂

The downside is that the input folder has 14500 text files,...

I did and i got MORE errors.

I am using a small sample of test data that can be configured any way i choose.

On my live data i am storing various text files with different positioning of...

idQueryImporteddate

1"MASTER.DBO.xp_cmdshell 'bcp ""Bank.dbo.Account""

in ""c:\Myimport\a.txt"" -SSQL -T -c -r -t,'"31:21.1

2usage: bcp {dbtable | query} {in | out | queryout | format} datafile31:21.1

3 [-m maxerrors] ...

220 [-i inputfile] [-o outfile] [-a...

I still get nulls in the Account Table 🙁

Thanks

I am running this query to use the BCP. This is my .txt file.

1, mak, a9411792711, 3400.25

2, bob, b9999999999, 2400.99

The job runs fine and i get no errors but i...

I am getting a bulk insert error using the following data in a csv file.

Any ideas ?

Thanks

1, MAK, A9411792711, 3400.25

2, Claire, A9411452711, 24000.33

3, Sam, A5611792711, 1200.34

id(int,null)

name(varchar(100),null)

accountno(varchar(100),null)

balance(money,null)

(3 row(s) affected)

(1 row(s) affected)

(2...

Thanks 😉

I was using the VB application since it made the parsing and loading process very low maintenance. The downside is that as my needs have increased, the performance is lacking.

I...

Yes that is the number of files.

Each file SIZE is between 30k and 35k.

The complete text documents are stored in one table, but the parsed information extracted from the text...

(1) I have a program written in VB6 that parses the text files, then i load after the parse process is complete. The parsing takes about

1 hour per 1k...

Thanks !

FTI was set to automatic, but i have a much smaller database (only 35GB).

I load approx 4k new text documents daily and then run a reindex(6 minutes), tlog backup (5...