nerdexam
Exams70-463Questions#153
Microsoft

70-463 · Question #153

70-463 Question #153: Real Exam Question with Answer & Explanation

The correct answer is C: Custom source component. HTML is not a format natively supported by any built-in SSIS data flow source. The Raw File source reads SSIS's proprietary binary format. The XML source reads well-formed XML documents - HTML, especially real-world HTML, is not valid XML. The Flat File source handles delimited o

Question

You are developing a SQL Server Integration Services (SSIS) package. The package sources data from an HTML web page that lists product stock levels. You need to implement a data flow task that reads the product stock levels from the HTML web page. Which data flow source should you use?

Options

  • ARaw File source
  • BXML source
  • CCustom source component
  • DFlat File source

Explanation

HTML is not a format natively supported by any built-in SSIS data flow source. The Raw File source reads SSIS's proprietary binary format. The XML source reads well-formed XML documents - HTML, especially real-world HTML, is not valid XML. The Flat File source handles delimited or fixed-width text files, not markup. Because none of the built-in sources can parse HTML, a Custom source component must be developed (using the SSIS object model or .NET) to connect to the web page, retrieve the HTML, parse the relevant content, and expose it as rows in the data flow pipeline.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice