nerdexam
Microsoft

70-448 · Question #189

You are developing a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from text files and loads the data to a SQL Server 2008 database. You configure the data flows to…

The correct answer is A. Configure the MaximumErrorCount property for the package. MaximumErrorCount is the maximum number of errors that can occur before a container stops running. The default value of this property is 1

Implement an SSIS Solution

Question

You are developing a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from text files and loads the data to a SQL Server 2008 database. You configure the data flows to fail on a single error. The control flow package is as shown in the following exhibit. (Click the Exhibit button.) The package extracts data from files that are stored in two folders. Each folder can store a maximum of 10 files. You need to ensure that the package runs and loads additional files even if an error occurs during the loading of a file. What should you do?

Exhibit

70-448 question #189 exhibit

Options

  • AConfigure the MaximumErrorCount property for the package.
  • BConfigure the FailPackageOnFailure property for each Foreach Loop container.
  • CConfigure the FailPackageOnFailure property for each Data Flow task.
  • DConfigure an OnError event handler for each Foreach Loop container.

How the community answered

(45 responses)
  • A
    73% (33)
  • B
    9% (4)
  • C
    2% (1)
  • D
    16% (7)

Explanation

MaximumErrorCount is the maximum number of errors that can occur before a container stops running. The default value of this property is 1

Topics

#error handling#MaximumErrorCount#Foreach Loop#package control flow

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-448 Practice