I personally would not fail the task. I would be looking for the duplicate
row up front of the DataPump. If there is a duplicate then I would avoid
the DataPump task and move to another task that hadled the error.

When you say Fail on error do you mean the task or the row?

How do you determine duplicate? Is it through Key values or through
Checking in a lookup?

You could try the Multiphase transform

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.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"DTS Dummy" <naman (AT) gsr-inc (DOT) com> wrote

the even if I have the workflow defind for on Failure it doesnot execute it
and just throws error and stops execution.