In the SSIS landscape, there are three categories of significant errors:
-
The Connection Manager cannot be started with the connection string, resulting in a data connection error.
-
A data transformation mistake happens while data is being converted through a data pipeline.
-
This sort of error happens when the expressions that are evaluated at runtime are incorrect.
Errors may arise when column data is converted, extracted from sources, or fed into a destination.
Data errors are managed in the data flow task by diverting the data flow using the error output of a component, whereas procedure faults are handled in the control flow by precedence control and redirecting the execution flow.