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 t

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

Extract and transform data

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

How the community answered

(35 responses)

A
3% (1)
B
6% (2)
C
86% (30)
D
6% (2)

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.

Topics

#data flow sources#custom source component#HTML data extraction#SSIS source types

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice