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 |
|
lawrac
Starting Member
1 Post |
 Posted - 2005-09-12 : 07:55:30
|
| Hello,We can load text file using bulk insert without any error but we have to respect the line's order and it doesn't work.Even with an index in temporary table in which the file is load, a line which is n# 5981 (for example) can be found after bulk insert at n#800.How force bulk insert to respect the order ? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-12 : 08:56:30
|
i don't know about ordering with bulk insert but it would seem to me that since there is no order in a table bulk insert wouldn't do anykind of order.you can always order your data with "order by" part of the select statement.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Bulk Insert Problem