ERROR HANDLING IN SSIS | EVENT HANDLERS IN SSIS
Автор: Training2SQL MSBI
Загружено: 2017-09-05
Просмотров: 27140
Описание:
Video talks about
ERROR HANDLING IN SSIS
Errors logging in ssis
ERROR HANDLING IN DATA FLOW IN SSIS
EVENT HANDLERS IN SSIS
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
Fail Component in SSIS
Ignore Failure in SSIS
Redirect Rows in SSIS
configure error output in SSIS
Also part of SSIS Interview Questions , MSBI Interview Questions and SSIS Training concepts, SSIS training Videos and SSIS Videos
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Error Handling in SSIS Packages [SSIS Event Handlers | SSIS Data Flow Task]](https://imager.clipsaver.ru/t-r8j7KN8Nk/max.jpg)
