" David N." <huongdat@comcast.net> wrote in message
news:uMsbI2v2DHA.1184@TK2MSFTNGP10.phx.gbl...
>
> 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.
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uJi8mDz2DHA.1704@tk2msftngp13.phx.gbl...
> 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%20Server\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@comcast.net> wrote in message
> news:uMsbI2v2DHA.1184@TK2MSFTNGP10.phx.gbl...
> >
> > 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.
> >
> >
>
>