Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining


SQL Server 2000

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.

See Also

Handling DTS Events and Errors

MaximumErrorCount Property

OnError Event

© 2015 Microsoft