There are three types of major errors in the SSIS landscape, namely:
Data connection error: This type of error occurs when the Connection Manager cannot be initialized with the connection string.
Data transformation error: This error occurs while the data is being transformed over a data pipeline.
Expression evaluation error: This type of error occurs if the run-time evaluated expressions are invalid.
When the column data is transformed, extracted from sources, or loaded into a destination, errors occur.
Procedure errors are handled in the control flow by the precedence control and by redirecting the execution flow, and data errors are handled in the data flow task by redirecting the data flow using the error output of a component.