Is thee a log file that can tell when records were deleted

I do a monthly update that uses about 20+ DTS packages to import and
update SQL 2000 tables. I have a few tables that somehow get empty.
The update package does truncate the destination table then adds records
from the "staging" table into the destination table. Which works fine.
I tested it several times and when the individual package runs I have
data in the destination table. But when all packages are run, the data
gets removed. So I am thinking that buried in one of my packages it's
deleting the records. I have yet to find it. So is there a way to trap
when records get deleted from this table? An event or is their a log?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!http://www.aspfaq.com/2449
For the future:
http://www.aspfaq.com/2448
http://www.aspfaq.com/2496
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Colin Colin" <ccole@.ghs.guthrie.org> wrote in message
news:uk6lbtx7DHA.2404@.TK2MSFTNGP11.phx.gbl...
> I do a monthly update that uses about 20+ DTS packages to import and
> update SQL 2000 tables. I have a few tables that somehow get empty.
> The update package does truncate the destination table then adds records
> from the "staging" table into the destination table. Which works fine.
> I tested it several times and when the individual package runs I have
> data in the destination table. But when all packages are run, the data
> gets removed. So I am thinking that buried in one of my packages it's
> deleting the records. I have yet to find it. So is there a way to trap
> when records get deleted from this table? An event or is their a log?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!