SQL Server Source Patterns - SQL Server Integration Services Design Patterns - page 129

Figure 4-4 . ODBC ADO.NET connection manager property screen
If you are using SQL Server 2012 or later, you can use the ODBC Source compon-
ent. Configuring the ODBC Source is very similar to the ADO.NET Source, except
that you use an ODBC connection manager. The ODBC Source provides additional
performance benefits over ADO.NET; however, it requires SQL Server Enterprise Edi-
tion to run outside of the SQL Server Data Tools environment.
OLE DB
Finally, we move on to what is arguably the most common connection manager used to
connect to SQL Server: OLE DB. The OLE DB protocol was written by Microsoft as
the next version of the ODBC provider. In addition to SQL Server databases, you can
use the OLE DB connection manager to connect to file-based databases or Excel
spreadsheets.