Hi Jeff !!!

Thank you..

I guess the keyword I had missed was "SET NOCOUNT ON"

I guess that might be the reason, why it was slow.

Also, I had set the db in...

No. The dashes aren't supposed to be delimiters.

There is only one column, and it stored the record as

05-06-07-08-09-10

04-06-07-08-09-10

etc,

in each row.

Sorry.. The pipe delimiter was a mistake.

And thanks for the knowledge on "table lock on bulk load" option.

Will try it and see.

Thank you..

Hi !!

Thank you for the inputs..

I had downsized the files for checking.

File Details:

3,838,380 rows

Size: 71,220 KB

Using BCP

*****************

First Run with Batch size = 1000

3838380 rows copied.

Network packet size (bytes):...

Very interesting..

More information on the work culture and test cases of some important problems they faced could be interviewed also.

Please keep up this good work.

Regards

Edward Anil Joseph