Microsoft
70-448 · Question #189
70-448 Question #189: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #189. The question stem and answer options stay visible for context.
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
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.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.