Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kontact00
Starting Member
3 Posts |
 Posted - 2009-10-28 : 07:59:51
|
| Hi, I have discovered the wonders of Openrowset to extract data out of flat files but to date Ihave only been using files with several thousand records.My task is to open the rowset and insert the contents of the text file into a DB table.ie INSERT into TableA (a, b, c, d)select a, b, c, dfrom Openrowset'MSDASQL', ..........)If the file I am opening has millions of records, At what point will the insert commit, ie once all records have been processed or is it possible to do a periodic commit?Thanks |
|
|
|
|
|
Openrowset to select and Insert Millions of record