sql server dts: Different Result Rets When Exporting Data. -- sql server dts

Different Result Rets When Exporting Data.

Arzan
9/11/2005 10:01:01 PM

sql server dts: 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.

Re: Different Result Rets When Exporting Data.

Allan Mitchell
9/12/2005 12:00:00 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.