3

I have a huge text file that has 1 million rows and each row there is only 28 length number as text. I want to import them into sql server that has table corresponding column. So that a million data will be inserted to one column DB table.

I used SSIS, it's kind of slow. (1 million data will be inserted in 4.5 hours or more) Are there any other ways to do that much faster ?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
Arno
  • 304
  • 1
  • 3
  • 11

2 Answers2

0

You can use BCP utility for fast import . See official documentation here : DOC

GeoVIP
  • 1,524
  • 9
  • 25
  • 45
0

As a result, I decided to sptling up the huge data into parts and run more SSIS at the same time through insert same table. There will be no lock in inserting. I hope 6 SSIS finish this job nearly about an hour.

Thanks.

Arno
  • 304
  • 1
  • 3
  • 11