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 |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2010-01-12 : 01:00:54
|
| Hi! I'm trying to run Bulk Insert and continue receivine error. Even tried some table in Adventure work (Currency), exported to Currency.txt file and still it fails with the message[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "D:\COPY\Currency.txt" could not be opened. Operating system error code 3(error not found).". What can be a problem? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-12 : 01:55:12
|
| is the file kept opened? are you able to otherwise access the file? |
 |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2010-01-12 : 09:41:03
|
| Hi ! File is closed, and I've already moved on with my problem. It looks like bulk insert works from the server only, not on remote. But now the error is more depressing - it points to conversion problems and truncation, but I enlarged my fileds in the table. I think the problem is with end-of-line symbols. And I don't know what to do. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-12 : 10:52:35
|
quote:
Originally posted by Tasta
Hi ! File is closed, and I've already moved on with my problem. It looks like bulk insert works from the server only, not on remote. But now the error is more depressing - it points to conversion problems and truncation, but I enlarged my fileds in the table. I think the problem is with end-of-line symbols. And I don't know what to do.
is your delimiters consistent? are you using format file? |
|
|
|
|
|
|
Bulk insert failure