Database Reference
In-Depth Information
Figure 8-5.
Configuring the Data Source connection manager
After you have chosen your connection, you will want to choose your data access mode. As you can see in Figure
8-6
, you can select from four separate options in an OLE DB connection manager:
•
Table or view
•
Table name or view name variable
•
SQL command
•
SQL command from a variable
Figure 8-6.
Configuring the data source data access mode