Hi,
we are using a DTS that basically transforms data from a Table in one
repository to a Table in another repository using a DataPump Task.
We also has a success workflow and a failure workflow after the Data Pump
Task (graphically it is linked to the destination Connection) in order to
manage error and success (and log this results and change our internal state
of the transaction).
If the transformation fails, the failure workflows is used (That's OK).
BUT if the destination connection fails (login, timeout, etc), the failure
workflow is not used (and our error handling code is never call).

Is this by Design? Is there any parameter or property that allow us to view
this connection error as part of the Transaformation and then make it
execute the failure workflow?

I think the workaround is make the package fail, and manage the error from
aoutside the DTS.

Any idea will be welcome.

Thanks

LucasC