Hi All,

Is there a way to tell DTS to log an error, or to call a stored procedure
that logs the error, to a SQL table in SOURCE and/or DESTINATION database?

Thanks.

You have to write your own.

In 2000 there are tables in msdb that you can enable in the package to do a
part of this. (sysdtssteplog, sysdtstasklog)

You could look to use the Multiphase data pump task to do this

Multiphase Data Pump (Field Notes)
(http://www.sqldts.com/default.aspx?282)

BOL:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dts
sql.chm::/dts_elemtsk1_2yux.htm

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


" David N." <huongdat (AT) comcast (DOT) net> wrote

Alan,

Thanks a lot.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote