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 |
|
rongrzywacz
Yak Posting Veteran
57 Posts |
 Posted - 2002-04-30 : 10:44:51
|
| When trying to run a SqlAgent job to bulk import a large file into a table, I ocassionally get the following error, "Could not bulk insert because file '(null)' could not be read. Operating system error code 997(Overlapped I/O operation is in progress.)" The file we are trying to load is on a different server, but we are running the job at 4 Am when there is not much activity on the network. If the job fails, it is usually within the first 10 seconds. We are running Windows Server 2000, and SQL server 7.0. All of the latest service packs are installed. If I restart the job, it usually runs fine. Does anyone have any ideas on what the problem might be, where to look? Thanks for any help.RGRon Grzywacz |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-30 : 11:09:15
|
| Is it possible that the file is still in the process of being copied into its directory at 04:00 ? Or maybe there is a os backup in process...Maybe ask this guy if he ever figured it out . . . or this dude<O> |
 |
|
|
|
|
|
Bcp import - Overlapped I/O error