Click below for Step by Step and Interview Q & A (dotnetinter) wrote,
Click below for Step by Step and Interview Q & A

SSIS, SSRS and SSAS(MSBI) interview questions: - What are Precedence constraints in SSIS?

Precedence constraints are used in control flow of SSIS designer.

  1. 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.

sql 1

     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

sql 2

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 or visit

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: -

Tags: csharp interview questions, it interview questions with answers, msbi, precedence constraints, programming interview questions, ssas, ssis, ssis ssas and ssrs(msbi) questions, ssrs

  • How to create an OLAP Cube?

    This article will have no theory rather than it will have only be demonstrating practical step by step in detail included to create SSAS OLAP Cube:…

  • Instrumentation is SSIS using Data Taps

    In this short article we will hover around some important questions related to Instrumentation done in SSIS using Data Taps. We will only discuss…

  • Create job using SQL Server Agent step by step.

    In MSBI while working on SSIS projects we have to run repetitive task which has to carried out daily like running package or to take weekly backup…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded