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 |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2001-12-29 : 07:40:32
|
| hai guys,i am using "bulk insert" from a file.If it has some unformatted data then it will return an error No. and the description saying that it was not able to insert the so and so line.I want to stored the error description( not the error number) and return to the client.IT might have failed to insert more rows also from the file.I want to capture all those descriptions |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-29 : 15:37:17
|
| If you use bcp you can specify an error file then open the file after the operation and return the results (or just email the file or tell the user to look at it).==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
sona
Yak Posting Veteran
68 Posts |
Posted - 2001-12-30 : 22:54:54
|
| No, I am using BULK INSERT command.Is there any other way than writing in a file , but returning it to the client in a recordsetthanks |
|
|
|
|
|
|
Error logging