InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 11:29:06 GMT20http://www.sqlservercentral.com/Forums/Topic1381177-364-1.aspxYeah that helps. I also found this article that explain how to connect to DBF :-)http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/think-carefully-which-sql-server-you-wanTue, 06 Nov 2012 07:15:08 GMTkelster101757http://www.sqlservercentral.com/Forums/Topic1381177-364-1.aspxNot sure how much guidance you need here but you can use 64-bit SSIS to use 34-bit drivers as you can run it in 32-bit modeTo create 32-bit drivers on a 64-bit machine you can run the 32 bit version of ODBC admin ie C:\WINDOWS\SysWOW64\odbcad32.exeWhen you are running your SSIS package you can run that in 32-bit mode by running the package with /x86 commandie dtexec /DTS "\File System\my_package" /SERVER localhost /CHECKPOINTING OFF /REPORTING V [b]/x86[/b]Does this help?MackMon, 05 Nov 2012 10:11:51 GMTMackershttp://www.sqlservercentral.com/Forums/Topic1381177-364-1.aspx[quote][b]Mackers (11/5/2012)[/b][hr]Is this Integration Services or Analysis Services you need help with? You post says SSAS but it sounds like you mean SSISMack[/quote]your right, i meant intergration services. Ive now changed the question. ThanksMon, 05 Nov 2012 10:04:13 GMTkelster101757http://www.sqlservercentral.com/Forums/Topic1381177-364-1.aspxIs this Integration Services or Analysis Services you need help with? You post says SSAS but it sounds like you mean SSISMackMon, 05 Nov 2012 10:01:04 GMTMackershttp://www.sqlservercentral.com/Forums/Topic1381177-364-1.aspxHi, I'm pretty new to integration services and I'm trying import data from a DBF database. What's the best way to do this? We're using Windows 2008 R2 64bit with SQL server R2.I've opened the tables on a Windows 7 32bit machine using Excel using the following method:- Installed the 32bit Foxpro driver http://msdn.microsoft.com/en-us/vfoxpro/bb190233 - no 64bit reader - Created a ODBC connection using 32bit ODBC - Created a ODBC data source using the Microsoft DBase VFP driver and chose database type "free table directory" - Open customer database in Excel (needs to be a 32bit program)Your help would be appreciated! ThanksMon, 05 Nov 2012 09:54:30 GMTkelster101757