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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  bulk insert timeout expired

Author  Topic  g3 Starting Member 1 Post Posted - 2005-01-28 : 11:53:45 Hi all I had developped a vc++ application using SQL server 2000 as back end. I am dumpping 140 MB file to the table using BULK INSERT statement with 500 batch size. Even then sometimes I am getting timeout expired error. So i changed the ODBC Connection Polling retry wait time from 120 to 520. then sometimes i am not getting timeout. worst thing is sometimes application is terminating successfully without dumpping the entire file. can any one help me out to solve this problem it is very very urgent thanx in advance, g3.