The Visual FoxPro connector is an object that is used to get data from Visual FoxPro databases.
After adding the connector to the ETL task workspace, set basic properties and import options. The connector output can also be edited and data filtering options can also be set.
The Import Options page is used to specify a file with imported data and parameters used to determine data range.
The Visual FoxPro Database and Directory Containing Visual FoxPro Files radio buttons enable user to determine provider type.
Select the required file from a Visual FoxPro database or from a directory containing Visual FoxPro files.
Enter the query text, in accordance with which the data is selected, in the Query input box.
The Settings button enables the user to determine advanced settings used on identifying data.
The Browse Data button shows data selected by a query.
NOTE. Only the first hundred of the provider lines will be displayed during the data preview.
See also: