Database Reference
In-Depth Information
The OLE DB Source Connection Manager Page
The “Table or view” option shown in Figure
8-7
allows you to select a table or view from the data source. The table
name and view name variables do the same thing, as long as you place the name of the table or view in an SSIS
variable. When you use the “Table or view” option, you are presented with a list of tables and views to select from,
based on your chosen connection manager.
Figure 8-7.
Using the “Table or view” data access mode
■
using either one of these options is similar to using
SELECT * FROM <Some table>
, bringing all of the
columns from that table even if they will never be of use. Therefore, always try to use either a sQl view that restricts
the data you get from a table or the “sQl command” data access mode and include only the required columns in
your sQl code.
Note
