Database Reference
In-Depth Information
Figure 12-4 . The Preview dialog from the OData Source Editor
After configuring the collection or resource path value, you can select the columns
you want to retrieve for your data flow by clicking on the Columns page (shown in
Figure 12-5 ) . This dialog uses the standard SSIS external column dialog and should be
familiar to SSIS developers. Note that unselected columns on this page won't be added
to your data flow, but they will still be pulled down by the request to the service. If you
are only selecting a few columns from a given feed, you might want to limit the
columns upfront using the $select query option. More information about query op-
tions can be found in Table 12-3 .
 
 
Search WWH ::




Custom Search