Mark wrote:
> I'm having an issue when doing a bulk insert on a SQL 2000 server. I
> need
> the table rows to load in the exact order that the rows in the text
> file are
> sequenced.
>
> So far, the bulk insert appears to be loading the file in 2 different
> orders. One of the orders is the same order as the text file. The
> other
> order is completely different and does not appear to have any reason to
> be in
> the different order.
>
> I've tried setting the BATCHSIZE argument to 1 and that doesn't fix it.
>
> Using the ORDER argument doesn't help either because the destination
> table
> doesn't have a primary key plus I don't want to change the order of the
> text
> file anyways.
>
> Is there a way to ensure the BULK INSERT loads the file in the exact
> order
> that the text file is in?

Mark wrote:
> I'm having an issue when doing a bulk insert on a SQL 2000 server. I
> need
> the table rows to load in the exact order that the rows in the text
> file are
> sequenced.
>
> So far, the bulk insert appears to be loading the file in 2 different
> orders. One of the orders is the same order as the text file. The
> other
> order is completely different and does not appear to have any reason to
> be in
> the different order.
>
> I've tried setting the BATCHSIZE argument to 1 and that doesn't fix it.
>
> Using the ORDER argument doesn't help either because the destination
> table
> doesn't have a primary key plus I don't want to change the order of the
> text
> file anyways.
>
> Is there a way to ensure the BULK INSERT loads the file in the exact
> order
> that the text file is in?