visual foxpro odbc driver | Microsoft Technologies

For the migrating data from Foxpro database to SQL there is two solution as below

Requirement :

Before starting the steps, please make sure the Microsoft OLE DB Provider for Visual FoxPro and Visual FoxPro ODBC Driver is installed.

Solution1:

Use the Microsoft OLE DB Provider for Visual FoxPro to load data from Visual FoxPro database

Create a new SQL Server Integration Services(SSIS) package.
Add a Data Flow Task(DFT) to the package.
Select the DFT, and go to Data Flow designer page.
Add a OLE DB Source to the package.
Double-click the OLE DB Source, click “New” > “New” to create a connection to Visual FoxPro.
In the Connection Manager, please select “Microsoft OLE DB Provider for Visual FoxPro”
Type the file path of a Visual FoxPro database(e.g. C:\Address.dbc).
Test the connection by clicking button “Test Connection”
Click “OK” > “OK” to apply.
Now, we can select a table from the Visual FoxPro database in the OLE DB Source editor.

Solution2:

Use the Visual FoxPro ODBC Driver to load data from Visual FoxPro database

As you done, create a DSN pointing to VFP free table using odbcad32 from SysWOW64 folder. I would suggest you using System DSN instead of User DSN.
Create a new SQL Server Integration Services(SSIS) package.
Add a Data Flow Task(DFT) to the package.
Select the DFT, and go to Data Flow designer page.
Add an ADO NET Souce to the package. Please note, ADO NET is started to support from SSIS 2008. In other words, in SSIS 2005, there is no ADO NET source.
Double-click the OLE DB Source, click “New” > “New” to create a connection to Visual FoxPro.
In the Connection Manager, please select “Odbc Data Provider”
Select the DSN we created before, and then test the connection, make sure it is successful.
Click “OK” > “OK” to apply.
Now, we can select a table from the Visual FoxPro database in the ADO NET Source editor. If it is fail, please try using SQL Command mode.

Microsoft Technologies