The IDTSDataPumpErrorSink interface provides optional error sinks for the source, transformations, or destination to data pump consumers. Only one of the error sink methods is called for each row, and the method called indicates where the error was encountered.
The error sinks determine the appropriate response to the error. The response is one of the following:
- Terminate the data pump.
- Increment an error count and continue if the error count does not exceed the value of the MaximumErrorCount property.
- Continue the data pump operation.
The error information is written to the exception file and the package OnError event is raised if a handler has been provided.