"Blaz Ziherl" <BlazZiherl@discussions.microsoft.com> wrote in message news:255A49C6-1077-4193-9BA4-B4F13CFB4339@microsoft.com...
> Hi,
>
> I have build my own custom transformation and tested it by copying a source
> table with 50000 records to the destination table. The records were copied in
> a strange order. Is this a normal SQL server behaviour, or is this issue
> related to my custom transformation?
>
> Regards,
> Blaz Ziherl

"Allan Mitchell" wrote:

> What makes you say they were copied in a strange order?
>
> Remember in SQL Server there is no such thing as an order unless you explicitly tell the query ORDER BY.
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - SQL Server 2005 Integration Services.
> www.Konesans.com
>
>
> "Blaz Ziherl" <BlazZiherl@discussions.microsoft.com> wrote in message news:255A49C6-1077-4193-9BA4-B4F13CFB4339@microsoft.com...
> > Hi,
> >
> > I have build my own custom transformation and tested it by copying a source
> > table with 50000 records to the destination table. The records were copied in
> > a strange order. Is this a normal SQL server behaviour, or is this issue
> > related to my custom transformation?
> >
> > Regards,
> > Blaz Ziherl
>
>