You are developing a SQL Server Integration Services (SSIS) package. The package sources data from an HTML web page that lists product stock levels. You need to implement a data flow task that reads t

Question

Options

• AUse an msi file to deploy the package on the server.
• BOpen a command prompt and run the dtutil/copy command.
• CAdd an OnError event handler to the SSIS project.
• DOpen a command prompt and run the gacutil command.

• A
  2% (1)
• B
  88% (36)
• C
  2% (1)
• D
  7% (3)

Explanation

This question contains a mismatch between the question stem and the answer choices - a known issue in some exam question banks. The stem asks about a data flow source for reading HTML web page data (for which a Script Component used as a source would be the correct SSIS answer), but the answer choices describe package deployment operations. The listed correct answer, B - 'Open a command prompt and run the dtutil /copy command' - is a deployment action: dtutil is the SSIS command-line utility, and /copy transfers a package from one storage location to another. The explanation for why B is marked correct here is that the answer choices belong to a different question that was incorrectly paired with this stem.

No community discussion yet for this question.