I built and ran a automatic DTS package that completed with a 'successful
completion' message. However, some tables (applic and people) showed
different counts at the target database than those on the source.

When the same DTS job was run again (manually this time) the counts were
identical for all tables.
Can some tell what the problem could be?
Also what is the best way to create a detailed report for the out of the
aotomated package in sql2000