- It let us decide the sequence in which tasks should be executed.
For example let say we have added Execute SQL task and Backup database task in the control flow.
If we directly execute our SSIS package, it will make both of our task execute in parallel.
Using precedence we control what need to be executed first and what next.
2. It let us decide condition when the next task should execute.
For example we can say If Execute SQL Task,
- Succeeds, then only Backup Database task should execute.
- Fails, then some script task should execute
Note: Other Fail and Success there is one more stage that is complete. It make use execute task in every condition. Example execute next task if current task succeeds or fails.
For BI Step by Step series click here.
For technical trainings on various topics like WCF, MVC, Business Intelligence, Design Patterns, WPF, TFS and Basic fundamentals feel free to contact SukeshMarla@Gmail.com or visit www.sukesh-marla.com
For more stuff like this, click here. Subscribe to article updates or follow at twitter @SukeshMarla
Also see another SSIS, SSAS and SSRS(MSBI) interview questions video on basics of SSIS , SSAS and SSRS: -