Redirecting error rows using ssis

Video talks about
Every executable execution in ssis is event based.
Configure error output:
Data flow task pipeline error handling implemented with configure error output
a. Fail component
b. Ignore failure
c. Redirect row
Fail component:
If any error occurred in the data flow processing, data flow terminated and component failed
Ignore failure:
If any error occurred in the data flow processing, error causing rows (bad rows) will be ignored and good rows continued in the data flow.


Redirect row:
Error causing rows (bad rows) will be redirected to other transformation or destination adaptor and data flow continued with good rows.
     In data flow pipe line
Two types of errors
a. Common errors processing logic related
b. Truncate errors –data type sine related


Step by step SQL Training videos
Step by step SSIS Training videos
SSIS Tutorial


For more videos
@training2sqlmsbi

• #science_technology
• #ssis
• #sql
• #redirecting_error_records
• #redirecting_error_records_using_ssis
• #capture_error_records_in_ssis
• #capture_error_records
• #ssis_capture_error_records
• #ssis_error
• #ssis_error_rows
• #rows
• #records
• #redirecting
• #ssis_redirecting_error_rows
• #redirecting_error_rows_using_ssis
• #data_flow_task_error_handling_in_ssis_package
• #data_flow_task_redirect_rows
• #redirect_rows_from_flat_file_source
• #redirect_row
• #ssis_redirect_row
• #dynamic_connection
• #error_output
• #business_intelligence_tools