Hi all,

I'm pulling my hair out trying to do some error trapping.

I have a "Transform Data" task, which exports data from a Oracle table to
Sql Server table. For any given row that FAILS to export, I need to find the
rowID field from the database table in Oracle and sends an email to a
specified email address.

I'm trying to add a "Send Mail Task" on Failed precedence from my "Transform
Data" task to alert the administrator. However, I do not see any option of
passing a parameter indicating the rowID that is failing.

Can anyone advice me on how to pass parameter when a Transform Data task
failed?

Thanks!


--
Regards,
Keng Yuen

Turn on Multphase datapump if it not already turned on.
Then in the insert or transform error phase you can send out an email
based on source data. You will have to write an activex script for the
phase i.e. insert error