You need to extract data from delimited text files. What connection manager type would you choose?

Question

Options

• AA Flat File connection manager
• BAn OLE DB connection manager
• CAn ADO.NET connection manager
• DA File connection manager

• A
  87% (26)
• B
  3% (1)
• C
  3% (1)
• D
  7% (2)

Explanation

A Flat File connection manager (A) is purpose-built for reading from and writing to plain text files, including all common delimited formats such as CSV (comma-separated), TSV (tab-separated), and fixed-width files. It lets you define the column delimiter, text qualifier, row delimiter, header rows, and per-column data types directly in the connection manager properties. An OLE DB connection manager (B) and an ADO.NET connection manager (C) are designed for relational database sources and cannot read raw text files. A File connection manager (D) provides a path reference to a single file for operations like executing scripts or logging, but it does not parse or stream the file's delimited content into a data flow - that is exclusively the role of the Flat File connection manager.

No community discussion yet for this question.