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?
A.
Configure the MaximumErrorCount property for the package.
B.
Configure the FailPackageOnFailure property for each Foreach Loop container.
C.
Configure the FailPackageOnFailure property for each Data Flow task.
D.
Configure an OnError event handler for each Foreach Loop container.
Explanation:
MaximumErrorCount is the maximum number of errors that can occur before a container
stops running. The default value of this property is 1