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
webservice task?
no.
Webservice task does this:
“riting to a variable the values that a Web service method returns. For example, you could obtain the highest temperature of the day from a Web service method, and then use that value to update a variable that is used in an expression that sets a column value.
Writing to a file the values that a Web service method returns. For example, a list of potential customers can be written to a file and the file then used as a data source in a package that cleans the data before it is written to a database.”
https://msdn.microsoft.com/en-us/library/ms140114.aspx
Why not a script componet?
Why not a script componet?