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

A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database.
To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a comma-separated values (CSV) file that contains one row per currency.
You need to download the CSV file to the environment.
What should you use to retrieve the document from the website?

Answer options

• A. a Script component
• B. a Web Service task
• C. a Web Service source
• D. a Script task

Correct answer: D

Explanation

The correct answer is D, a Script task, because it allows for custom scripting to retrieve files from a web source, which is necessary for downloading the CSV. The other options, while useful for different tasks, do not provide the flexibility needed to directly download a file from an HTTP website.