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-04-09 : 12:31:00
|
| Keith writes "We are using BCP to load a data file into a temporary table. The data in the file has no particular key to order the data but we would like the temporary table to keep the same order as the data is in the file. This works 99 times out of a hundred, however, sometimes the order of the data in the temporary table is not the same as that in the file. We have a trailer record on the data file and sometimes this appears somewhere in the middle of the temporary table. Any ideas?" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-04-09 : 12:35:43
|
| Do you have multiple porocessors? Try restricting it to one.It's because bcp can use multiple threads to speed up performance.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
BCP does not always load a file in the correct order