What should you use to retrieve the document from the website?

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?

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?

A.
a Script component

B.
a Web Service task

C.
a Web Service source

D.
a Script task

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Calvin

Calvin

Can someone verify this answer. It should be A

Reply

Aakash

Aakash

D is correct. It asks just to download the CSV which can be done on control flow.

Reply

jin

jin

retrieve the document from the website – doesnt this mean extract of etl which happens in data flow? so it should be A-Script component

Reply