SQLKnowItAll (2/23/2012)
It doesn't look like that will do any good since the identifiers for the event are on a separate line.
Not sure what you mean by this, since each row will have a unique ID you can range the data between Events by ID
Plus, I'm not sure that you can "guarantee" that the data will be loaded in the order of the file. This file really has to be parsed before being loaded.
"Guaranteed" or not I have always found that bulk load into a table with IDENTITY column always have ID matching the row number of the input.
Maybe it should not be relied on but it works for me 🙂
Besides using 'Event' as the row terminator is prpbably the best (wish I had thought of that :-D) although the data will have to split/parsed in sql server instead of being in rows already.
But it all comes down to how the data will be processed and used.
Far away is close at hand in the images of elsewhere.
Anon.