70-463 · Question #180
70-463 Question #180: Real Exam Question with Answer & Explanation
The correct answer is D: a Script task. A Script task (control flow) is the correct choice for downloading a file from an HTTP URL. It allows you to write custom .NET code using System.Net.WebClient or HttpWebRequest to fetch the CSV from the public website and save it locally before processing. A Web Service task (B)
Question
Options
- Aa Script component
- Ba Web Service task
- Ca Web Service source
- Da Script task
Explanation
A Script task (control flow) is the correct choice for downloading a file from an HTTP URL. It allows you to write custom .NET code using System.Net.WebClient or HttpWebRequest to fetch the CSV from the public website and save it locally before processing. A Web Service task (B) is designed specifically for calling SOAP-based web services, not for downloading arbitrary HTTP files. A Script component (A) lives in the Data Flow and is used for row-level transformations, not for fetching external files. 'Web Service source' (C) is not a standard SSIS component. Because this is a pre-data-flow setup step (downloading the file to the environment), the Script task in the Control Flow is the right tool.
Community Discussion
No community discussion yet for this question.