November 5, 2012 at 9:54 am
Hi, 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! Thanks
November 5, 2012 at 10:01 am
Is this Integration Services or Analysis Services you need help with? You post says SSAS but it sounds like you mean SSIS
Mack
November 5, 2012 at 10:04 am
Mackers (11/5/2012)
Is this Integration Services or Analysis Services you need help with? You post says SSAS but it sounds like you mean SSISMack
your right, i meant intergration services. Ive now changed the question.
Thanks
November 5, 2012 at 10:11 am
Not 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 mode
To create 32-bit drivers on a 64-bit machine you can run the 32 bit version of ODBC admin
ie C:\WINDOWS\SysWOW64\odbcad32.exe
When you are running your SSIS package you can run that in 32-bit mode by running the package with /x86 command
ie dtexec /DTS "\File System\my_package" /SERVER localhost /CHECKPOINTING OFF /REPORTING V /x86
Does this help?
Mack
November 6, 2012 at 7:15 am
Yeah 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-wan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply