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 - 2004-02-10 : 07:49:15
|
| Sanya writes "What I want to do is that from a text file containing values and using another format file ,I want to bulk copy the data into a sql table.Each time i execute the statement, even when the text file is empty ,it gives 5 rows affected and some exponential values are inserted into the table.I suspect that it has got sumthing to do withthe "collation" value that we specify.Are there any changes that are to be made when one uses the collation field in the format file that we create.Also please tell how do we go to the interactive mode of BCP?and access the bcp utility.Thanx so muchwaiting for a quick reply" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-02-10 : 13:47:05
|
| The "5 row(s) affected" refers to the number of lines ("rows") of thebcp.exe's output (just some useful info) that xp_cmdshell re-sendsto QA (you see these "false" "rows" in QA's result window):1.Starting copy...2.3.7 rows copied.4.Network packet size (bytes): 40965.Clock Time (ms.): total 1 Avg 0 (7000.00 rows per sec.) |
 |
|
|
|
|
|
Bulk Copy and bulk insert