Re: Audits

#1

The way I would implement this is through attributes held on the
destination. Typically I may have attributes such as

UpdateDate
UpdateName
SourceSystemIdentifierKey
LoadKey

This would help me identify how the row of data managed to be where it is.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Gary Spence" <GarySpence (AT) discussions (DOT) microsoft.com> wrote

Quote:

My apologies for my first submission going in twice ( Igot an error mess.
on the first one !).
Is there a method to record the data you send in your DTS packages, for
viewing at a later date, most of my packages are empty, but when i send data

I would like to see what I've sent and if it is OK then delete the data, and
check it again the next day...and so on !

Quote:

Much Obliged

#2

Not sure if this will help but have you had a look at C2
Audit Mode for SQL?

Quote:

-----Original Message-----
The way I would implement this is through attributes held
on the
destination. Typically I may have attributes such as

UpdateDate
UpdateName
SourceSystemIdentifierKey
LoadKey

This would help me identify how the row of data managed
to be where it is.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Gary Spence" <GarySpence (AT) discussions (DOT) microsoft.com
wrote in message
news:FE6CF56E-24F8-49B6-BF8C-0D0A9F029180 (AT) microsoft (DOT) com...
My apologies for my first submission going in twice (
Igot an error mess.
on the first one !).
Is there a method to record the data you send in your
DTS packages, for
viewing at a later date, most of my packages are empty,
but when i send data
I would like to see what I've sent and if it is OK then
delete the data, and
check it again the next day...and so on !
Much Obliged

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Audits

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Audits - 07-02-2004 , 08:41 AM

Re: Audits - 07-02-2004 , 10:41 AM