Database Reference
In-Depth Information
Figure 7-25.
Adding a new connection to the Connection Manager tray
Connection managers are defined by their connection type. There are about 20 different connection types
available; some are installed by default, and others can be downloaded. Of all of these choices, you will frequently
use the following connection types:
•
The file connection manager
•
The OLE DB connection manager
•
The ADO.NET connection manager
Selecting one of these options is equivalent to selecting New Connection and choosing the provider from the
dialog you saw in Figure
7-25
. Microsoft conveniently placed these choices at the top of the context menu.
The File Connection Manager
The file connection manager allows you to work with both files and folders. This handy little connection manager
can perform operations such as creating new files and folders as well as accessing data from existing files.
In the business intelligence world, it is common to import data from files into staging tables and then
distribute it to the various tables in the data warehouse. Therefore, it is very likely that you will use these
connections when working with SSIS.
