"SteveH" <SteveH@discussions.microsoft.com> wrote in message
news:064D4D17-BA0D-4B33-A40B-B0AD0716D6F6@microsoft.com...
> If I use DTS to import a text file into a table that has an identity
> column
> and then queried the table and ordered by the identity column, am I
> guaranteed to get the rows back in the same order they appeared in my
> import
> file.
>
> I have tested this with a small file and it did, but not sure if it is
> just
> a coincidence.
>
> Thanks in advance
> Steve
>
>

"Russell Fields" wrote:

> Steve,
>
> Since the import of a text file will have a defined order, from the first
> row to the last, then the identity column will increment with each row.
> Your ordering should be fine.
>
> RLF
> "SteveH" <SteveH@discussions.microsoft.com> wrote in message
> news:064D4D17-BA0D-4B33-A40B-B0AD0716D6F6@microsoft.com...
> > If I use DTS to import a text file into a table that has an identity
> > column
> > and then queried the table and ordered by the identity column, am I
> > guaranteed to get the rows back in the same order they appeared in my
> > import
> > file.
> >
> > I have tested this with a small file and it did, but not sure if it is
> > just
> > a coincidence.
> >
> > Thanks in advance
> > Steve
> >
> >
>
>