Hi,

I have noticed a couple of times that when i use DTS to export data from
DatabaseA.TableA on Server 1 to DatabaseB.TableB on Server 2 the row count
is different in DatabaseB.Table B compared to DatabaseA.TableA after
successful export. Ideally the row count should be the same as there are no
transactions taking place against either on these tables.

Is this a bug?

Kindly let me know.

Thank you.

It is unlikely to be a bug. Can you identify the rows that do not make
it from the source? If you execute the same statement in Query Analyser
what results do you get?

Are there any errors?

How are you executing the package?

How are you doing the export?


allan



"Arzan" <Arzan (AT) discussions (DOT) microsoft.com> wrote