You are the administrator for your company’s SQL Server 2008 server. You have created a
package using SQL Server Integration Services (SSIS) and have modified some of the package
properties. (Click the Exhibit(s) button to view the properties you configured.)
When you run the package for the first time, a file not found error occurs. When you rerun the
package, the package is successful. You want to ensure that you can restart the package at the
point of failure and skip any tasks in the package that have already completed. What should you
configure?
A.
Set the SaveCheckpoints property of the package to True.
B.
Set the FailPackageOnFailure property to False.
C.
Set the CheckpointUsage property back to the default.
D.
Set the MaximumErrorCount property of the package to a high value.