All,

I get this error message with my OLE-DB Command Transformation runs. I'm
deliberately (business logic) causing my trigger to fail. I want to continue
processing the but the my transformations stop without execute the "error
redirect"

[DTS.Pipeline] Error: The ProcessInput method on component "Header Table
Command" (262) failed with error code 0xC0202009. The identified component
returned an error from the ProcessInput method. The error is specific to the
component, but the error is fatal and will cause the Data Flow task to stop
running.

Is there a way I can get my OLE_DB Command Transformation to continue
processing?

Hammer