>>Why would you do that when you can run an IS package in 32-bit mode?
>>
>>>Looks like you'll have to install a 32bit version of sql
http://blogs.lessthandot.com/index.php/All/?p=929>
>Oh - my bad
See
How to run SSIS package - Import VFP table to SQL Server 64 bitAnswer by Jin Chen in the above mentioned thread:
In order to load data from Visual FoxPro to 64-bit SQL Server, we can use Microsoft OLE DB Provider for Visual FoxPro or Visual FoxPro ODBC Driver to load data from Visual FoxPro, and then upload into SQL Server.
Below are the detail steps for your reference:
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.
Additionally, we strongly recommend using the Visual FoxPro OLE DB provider as a replacement. Also, in design-time, pleaes set the package to run in 32-bit mode, otherwise the package will fail to run.
Right-click the project > "Properties" > "Debugging" > Set "Run64Runtime" to be "False".
The two drivers can be downloaded from:
http://www.microsoft.com/downloads/en/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=enhttp://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx
If it's not broken, fix it until it is.
My Blog