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
Why not a script componet?
Yes, why not a script componet?
I think because downloading a file is rather a control flow task, than data flow component.
I agree with jml.
https://msdn.microsoft.com/en-us/library/ms140114(v=sql.110).aspx