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

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 (AT) discussions (DOT) microsoft.com> wrote

Yeah, I read several times that there is no such thing as an order, unless
you use ORDER BY, which makes sense. I just needed to make sure that it's not
me doing something wrong.

Anyway: Thanks for your answer.

"Allan Mitchell" wrote: