Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 — Question 26

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 the product stock levels from the HTML web page.
What should you do?

Answer options

• A. Use an msi file to deploy the package on the server.
• B. Open a command prompt and run the dtutil/copy command.
• C. Add an OnError event handler to the SSIS project.
• D. Open a command prompt and run the gacutil command.

Correct answer: B

Explanation

The correct answer is B because the dtutil/copy command is used to manage and copy SSIS packages, which is relevant for setting up your data flow task. The other options do not directly pertain to the task of reading data from an HTML webpage: A involves deployment, C relates to error handling, and D is for managing the Global Assembly Cache, none of which are necessary for the data flow task.