Database Reference
In-Depth Information
connection managers. But, keep in mind that they are more difficult to work with. Microsoft's website provides
a great deal of information on this topic. For more information, search for the topic of “ssis data types” at
Configuring a Connection
Each time you add a new connection, you need to configure it. Once you select a connection manager and click
the Add button, a configuration dialog appears (Figure
7-26
).
Figure 7-26.
Each connection manager type has its own configuration manager
This new dialog is dependent on which type of connection manager you selected, and each connection
manager type has its own configuration dialog. If you select an ADO.NET connection manager, for example,
you are presented with the Configure ADO.NET Connection Manager dialog. If, instead, you choose an OLE DB
connection manager, you will be presented with the OLE DB version of this dialog.
In both the OLE DB and ADO.NET configuration dialogs, Visual Studio remembers any previous
connections you have created either in this project or in past projects. Therefore, if you have connected to a
database in a previous project, these connections are still available. For example, since we previously created a
connection to the DWWeatherTracker database in Chapter 2, this connection is displayed in Figure
7-26
.
