Developing business intelligence solutions

Posted on
Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Questions derived from the 70-445 – TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance Microsoft Self-Test Software Practice Test.

 

Objective: Developing business intelligence solutions by using SSIS
SubObjective: Create control flow by using the control flow designer

 

Item Number: 70-445.8.3.5
Single Answer, Multiple Choice

 

You are a database administrator for your company. You have maintained your company’s database in a SQL Server 2005 server and in the form of XML files. You create a package in Integration Services using BIDS to extract data from the database. You have created two sequence tasks in the package. The first task fetches data from the database by using a SQL statement, and the second task fetches data from the database using XML statements. You have to ensure that the second task is executed only if the first task fails.

 

What should you do to accomplish the mentioned requirements?

 

 

  1. Add a failure constraint in the Control Flow tab.
  2. Add a failure constraint in the Data Flow tab.
  3. Configure the FailPackageOnFailure property on the Data Flow tab.
  4. Configure the FailPackageOnFailure property on the Control Flow tab.

 

Answer:
A. Add a failure constraint in the Control Flow tab.

 

Tutorial:

 

To ensure that the second task is executed only if the first task fails, you should add a failure constraint in the Control Flow tab. The Control Flow tab is used to define tasks that the package will perform. The control flow defines the overall operation of the package and represents the sequence of tasks that will be performed by the package. In this scenario, you should use the Control Flow tab to define the sequence of the two alternate tasks. You can control the sequence of the tasks by using precedence arrows options. The second task will be executed only if the first task fails. To achieve this, you are required to change the type of the precedence arrow to failure and that is possible only by using the Control Flow tab.

 

The option stating that you should add a failure constraint in the Data Flow tab is incorrect because you cannot add a failure constraint in the Data Flow tab. You have to use the Control Flow tab to define the sequence of two alternate tasks. You should change the type of precedence arrow to failure and that is only possible by using the Control Flow tab. The Data Flow tab is used to specify the data flow tasks for the package.

 

The options stating that you should configure the FailPackageOnFailure property on the Data Flow tab or the Control Flow tab are incorrect. The FailPackageOnFailure property is used to specify the restart point for all containers in the package. You cannot control execution of the second task using the FailPackageOnFailure property.

 

Reference:
Precedence Constraints
http://msdn2.microsoft.com/en-us/library/ms141261.aspx

 

Creating Package Control Flow
http://msdn2.microsoft.com/en-us/library/ms140234.aspx

Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment:

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>