InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How is error handling done in SSIS? |
|
Answer» During the process of TRANSFERRING millions of records from one SOURCE to a DESTINATION, the probability of errors always exists. It is very important to identify the records that are errored out and ensure the transmission of records is smooth with no errors to the destination. To identify the errors, the errors need to be logged. The components of SSIS - source, TRANSFORMATION, and the destination - all have had support to log errors to output by means of secondary pipe by providing means to define behaviors while errors occur. The secondary pipe or the error flow can be connected to another transformation or a destination component depending on the requirement. The error log can CONTAIN details regarding the error columns, error descriptions, and error codes. |
|