Data captured in Excel and CSV reports, which are meant to be read by the human eye instead of by an automated process, represents a challenge to those who need to load it into the SSIS pipeline. These data sources typically include factual data and metadata, which gives context to the facts.

Below is the list of SSIS connectors, which can extract such data and their capabilities:

By Name Supported Formats 64 bit Provider Notes FAQ
Interactive Edge DataDefractor  Excel, CSV, SQL Server, Oracle, ODBC Yes See

Note: This article has been ported over from http://ssis.wik.is/ 

Note: If you were the owner of above article, update it to the latest or with other appropriate information.