RE: order of rows during bulk insert

Right there with Babe

Points: 720

June 20, 2010 at 12:40 pm

Thanks Lutz,

Unfortunately there is no true key to the data, and there are millions of rows (Manually adding them isn't going to work). The rows are ordered in a very specific relationship for example the data might look like this:

1xxxxx

2xxxxxxx

3xxxxxxx

1xxxx

2xxxxxx

3xxx

So 1 would be the header, 2 would be additional info, an 3 would be the details. however, the 3 are only related to the twos that are above it, and 2's are related only to the 1's above. I guess I am hoping that SSIS in sql2005 would always process and load the file from top to bottom. If this isn't the case, I'm hoping for a method to force it to do so.

Again, Thanks.

Tim

Kind Regards,
Tim
_{:cool:[font="Courier New"]The stone age did not end due to a lack of stones, nor will the information age end due to a lack of data.[/font]:cool:}