ssms 连接 ssis_SSIS连接管理器：OLE DB，ODBC，ADO.NET

ssms 连接 ssis

In this article, I will first give an overview of the OLE DB, ODBC, and ADO.NET SSIS connection managers. Then I will try to illustrate the difference between them when trying to connect to SQL Server.

在本文中，我将首先概述OLE DB，ODBC和ADO.NET SSIS连接管理器。 然后，我将尝试说明尝试连接到SQL Server时它们之间的区别。

This article is the 8th article in the SSIS feature face to face series which aims to remove confusion and to illustrate some of the differences between similar features provided by SQL Server Integration Services.

本文是SSIS功能面对面系列文章中的第八篇，旨在消除混淆并说明SQL Server Integration Services提供的相似功能之间的某些区别。

SSIS连接管理器 (SSIS Connection Managers)

In general, SSIS connection managers are used to configure a connection between SSIS and an external data source. There are different types of connection managers that are included in SSIS.

通常，SSIS连接管理器用于配置SSIS与外部数据源之间的连接。 SSIS中包含不同类型的连接管理器。

In this article, I will mention the SSIS connection managers listed in SQL Server Data Tools for Visual Studio 2017 with their description (The following table is taken from Visual Studio “Add SSIS Connection Manager” dialog):

在本文中，我将提及针对Visual Studio 2017SQL Server数据工具中列出的SSIS连接管理器及其描述（下表摘自Visual Studio的``添加SSIS连接管理器''对话框） ：

Connection Manager	Description
ADO	Connection manager for ADO connections
ADO.NET	Connection manager for ADO.NET connections
CACHE	Connection manager for cache
DQS	Connection manager for DQS Server (Data Quality Services)
EXCEL	Connection manager for Excel files
FILE	Connection manager for files
FLATFILE	Connection manager for flat files
FTP	Connection manager for FTP
Hadoop	Connection manager for Hadoop
HTTP	Connection manager for HTTP connections
MSMQ	Connection manager for the Message Queue task
MSOLAP100	Connection manager for Analysis Services connections
MULTIFILE	Connection manager for multiple files
MULTIFLATFILE	Connection manager for multiple flat files
ODATA	Connection Manager for ODATA Services
ODBC	Connection manager for ODBC connections
OLEDB	Connection manager for OLE DB connections
ORACLE	Connection manager for Oracle connections
PowerQuery	Connection manager for Power Query Source
SMOServer	Connection manager for SQL Server transfer tasks
SMTP	Connection manager for Send Mail Tasks
SQLMOBILE	Connection manager for SQL Server Compact connections
WMI	Connection manager for the WMI tasks

连接管理器	描述
阿多	ADO连接的连接管理器
ADO.NET	ADO.NET连接的连接管理器
缓存	缓存的连接管理器
DQS	DQS服务器的连接管理器（数据质量服务）
卓越	Excel文件的连接管理器
文件	文件的连接管理器
平面文件	平面文件的连接管理器
的FTP	FTP的连接管理器
Hadoop的	Hadoop的连接管理器
HTTP	HTTP连接的连接管理器
MSMQ	Message Queue任务的连接管理器
MSOLAP100	Analysis Services连接的连接管理器
多文件	多个文件的连接管理器
多文件	多个平面文件的连接管理器
ODATA	ODATA服务的连接管理器
ODBC	ODBC连接的连接管理器
OLEDB	OLE DB连接的连接管理器
Oracle	用于Oracle连接的连接管理器
PowerQuery	电源查询源的连接管理器
SMO服务器	用于SQL Server传输任务的连接管理器
SMTP	发送邮件任务的连接管理器
SQL移动	SQL Server Compact连接的连接管理器
WMI	WMI任务的连接管理器

SSIS connection managers are can be added from the connection managers tab located in the bottom of the main screen:

可以从位于主屏幕底部的“连接管理器”选项卡中添加SSIS连接管理器：

Figure 1 – SSIS connection managers tab

图1 – SSIS连接管理器选项卡

As mentioned in the SSIS connection managers tab, add a new connection manager, right-click inside the tab panel, and select the connection manager type from the context menu strip.

如SSIS连接管理器选项卡中所述，添加一个新的连接管理器，在选项卡面板内右键单击，然后从上下文菜单栏中选择连接管理器类型。