?

Log in

Previous Entry | Next Entry

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

Copy right www.questpond.com

Buy 600+ Real Time Interview Videos

Call +91-22-66752917 or mail us on questpond@questpond.com for more details on C#, .NET, ASP.NET, SQL Server interview question videos.

SQL Server interview question videos

Latest Month

March 2017
S M T W T F S
   1234
567891011
12131415161718
19202122232425
262728293031 

Tags

Powered by LiveJournal.com