Error Handling:
Control flow error handling will be implemented with the event also called as Event Handler. Data flow pipeline error handling implemented with configure error output.
Events: Every executable execution in SSIS is event based . Events allows you to change the control flow execution order. Events are also used to create Sub Packages in the control flow.
Events examples:
Debugging :
Data flow pipeline debugging can be implemented with Data Viewers.
Control flow task debugging can be implemented with Break Points and events.
Break Points:
Used to trace the task by task execution or event by event execution of a task. It can be set for any executables in the control flow. Break points has to be enabled based on the event executables
Navigation :
Control flow error handling will be implemented with the event also called as Event Handler. Data flow pipeline error handling implemented with configure error output.
Events: Every executable execution in SSIS is event based . Events allows you to change the control flow execution order. Events are also used to create Sub Packages in the control flow.
Events examples:
- On Validate
- On Pre execute
- On Progress
- On Post Execute
- On Error
- On Task Failed
- On Execution Status.
Debugging :
Data flow pipeline debugging can be implemented with Data Viewers.
Control flow task debugging can be implemented with Break Points and events.
Break Points:
Used to trace the task by task execution or event by event execution of a task. It can be set for any executables in the control flow. Break points has to be enabled based on the event executables
Navigation :
- Control Flow
- Right click on particular executables'
- Edit break point
- Check one or more events to enable the break points
- click ok
No comments :
Post a Comment