SSIS Connection Managers

Built-in Connection Managers:-

Type	Description
ADO	Connects to ActiveX Data Objects (ADO) objects.
ADO.NET	Connects to a data source by using a .NET provider.
CACHE	Reads data from the data flow or from a cache file (.caw), and can save data to the cache file.
DQS	Connects to a Data Quality Services server and a Data Quality Services database on the server.
EXCEL	Connects to an Excel workbook file.
FILE	Connects to a file or a folder.
FLATFILE	Connect to data in a single flat file.
FTP	Connect to an FTP server.
HADOOP	Connects to a Hadoop cluster.
HTTP	Connects to a Web server.
MSMQ	Connects to a message queue.
MSOLAP100	Connects to an instance of SQL Server Analysis Services or an Analysis Services project.
MULTIFILE	Connects to multiple files and folders.
MULTIFLATFILE	Connects to multiple data files and folders.
ODATA	Connects to an ODATA source.
OLEDB	Connects to a data source by using an OLE DB provider.
ODBC	Connects to a data source by using ODBC.
SMOServer	Connects to a SQL Server Management Objects (SMO) server.
SMTP	Connects to an SMTP mail server.
SQLMOBILE	Connects to a SQL Server Compact database.
WMI	Connects to a server and specifies the scope of Windows Management Instrumentation (WMI) management on the server.

Connection Managers Available for Download :-      

Type	Description
Azure Storage	Connects to an Azure general-purpose storage account.
Azure Subscription	Connects to an Azure subscription account.
ORACLE	Connects to an Oracle <version info> server.
SAPBI	Connects to an SAP NetWeaver BI version 7 system.
TERADATA	Connects to a Teradata <version info> server.