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 commaseparated 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
This is a ‘data flow scenario’, so I’d say use a Script Component: option A
It is only a Script Component that can be configured as a ‘source’, a ‘destination’, or a ‘transformation’. Script Task cannot; and, there are no Web Service Task/Source.
Oops. My mistake…it’s D
This incorrect. Should be B
https://msdn.microsoft.com/en-us/library/ms140114(v=sql.110).aspx