I need to extract data from tables in a database that I can only access via ODBC.
I have successfully created a connection in Connection Manager (ConnectionManagerType = ODBC) for this database.
However I’m unable to add this connection as a Data Flow Source. There is no ODBC Source option in the Toolbox.
This is a major because we have been using the system dsn Microsoft Visual Foxpro Driver to access free table directory .dbf files under ODBC with DTS for years. To install a new Microsoft OLEDB driver for foxpro is out of the question on a production system as it would cost many thousands of dollars to go through our BAT testing process
How do I extract data from tables in a database via ODBC?
Thanks in advance
Dave
There is too, though it's not marked as such. Use the Data Reader Source.|||You can use the script component as source.
|||Thanks for that the data reader souce can actually use a ODBC source. I have it working fine.
I do think there is a peformance overhead and its slower than the ODBC connector in DTS.
|||well that is interesting How can it connect to a foxpro file .dbf and matching .fpt file the .fpt files are used for memo text fieldsthe foxprpro ODBC driver does this for you behind the scenes
|||Vijay Thirugnanam wrote:
You can use the script component as source.
True, though it shouldn't be faster than using the prepackaged source connectors.
