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-12-08 : 08:27:09
|
| preeti writes "helloactually problem is that..............i generating txt file through bcp command and transfer this file restore the data from this text filebut i want record by record acknowleagement so how i can do it please give me relevant advice" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-08 : 08:29:01
|
| Why would you want that? It will slow down the process tremendously. bcp will notify you if there are any errors and will abort the entire batch anyway (unless you set a batch size) If no errors are thrown, then the entire file was imported. |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-12-08 : 08:57:03
|
| also: use set-based sql and constraints to validate your import AFTER it has all come in. It will validate "record by record" but it will do so for all records at once, after the I/O has completed.better yet, import into a staging table, validate, and then move to your regular table.- Jeff |
|
|
|
|
|
|
problem