When a data flow component applies a transformation to column data, extracts data from sources, or loads data into destinations, errors can occur. Errors frequently occur because of unexpected data values.
Type of typical Errors in SSIS:
Data Connection Errors, which occur in case the connection manager cannot be initialized with the connection string. This applies to both Data Sources and Data Destinations along with Control Flows that use the Connection Strings.
Data Transformation Errors, which occur while data is being transformed over a Data Pipeline from Source to Destination.
Expression Evaluation errors, which occur if expressions that are evaluated at run time perform invalid