How can I get my admin notified by an error which happens in Data pump? for
instance primary key violation?? I know that I can use "Send Email Task" but
how can I catch these kinds of Error in my Data pump's activeX??

Thanks

You may be able to use this

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Ray5531" <RayAll (AT) microsft (DOT) com> wrote

added 2 more function to my "Row Transformation" phase activeX script and I
assigned them to On insert failur and on Transform failure but I never get
the message boxes even if there is a Primary key violation.

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