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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-13 : 08:05:44
|
| Neil writes "I have been using bulk insert for processing large source data files that must be imported into our application database structure on a monthly basis, and so far has been working OK, the files in question are large fixed length files that are processed into bulk insert formatted files (i.e. '|' is used are the field terminator and '\r' used as the row terminator. So far the largest files have had about 500000 lines of data, however this month the files have grown slightly in that the largest now contains about 750000 rows of data. Now all files except the largest (750000 rows) are executing successfully, however the largest is resulting in a timeout error on the database, 'Actual Error: -2147217871, Timeout expired'. The bulk insert is being executed via a VB 6.0 application using the ADO conection object, i have tried to set the timeout option on the connection to maximum, with no success, is there a trick for this on the server?Thanks" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-08-13 : 12:33:49
|
| Maybe query governor cost limit (see BOL) is your case? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-13 : 12:51:55
|
| I would try doing the BULK INSERT in Query Analyzer instead of in your VB application. You need to see how long it takes to execute on the server. Also, do you have indexes on the table that you are importing into it? If you do, you might want to drop them before the BULK INSERT, then recreate them after successfully importing them. Indexes will slow you down on imports.Tara |
|
|
|
|
|
|
Bulk Insert Timeout Errors