The problem is that the line number is NOT a column in the source file.
I tested with a file of 10 million rows and it worked fine, but that's not enough for me to just say it works 100% of the time.
I guess I'm screwed until I find some REAL documentation. :w00t:
I just find it hard to believe that a OPENROWSET (BULK ...) command wouldn't, or doesn't have an option to retain the original file order. I've had one person tell me that they've had it not do that for them, which is why I posted here.
I guess I'll email MS and wait for an answer. I'll then post their reply here.
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.Jason L. Selburg