Importing from DBF

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Importing from DBF

Importing from DBF

Rate Topic

Display Mode

Topic Options

Author

Message

kelster101757

Posted Monday, November 05, 2012 9:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:07 AM
Points: 5, Visits: 16

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

Post #1381177

Mackers

Posted Monday, November 05, 2012 10:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:58 AM
Points: 117, Visits: 458

Is this Integration Services or Analysis Services you need help with? You post says SSAS but it sounds like you mean SSIS

Mack

Post #1381179

kelster101757

Posted Monday, November 05, 2012 10:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:07 AM
Points: 5, Visits: 16

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 SSIS

Mack

your right, i meant intergration services. Ive now changed the question.

Thanks

Post #1381182

Mackers

Posted Monday, November 05, 2012 10:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:58 AM
Points: 117, Visits: 458

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

Post #1381190

kelster101757

Posted Tuesday, November 06, 2012 7:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:07 AM
Points: 5, Visits: 16

Yeah that helps. I also found this article that explain how to connect to DBF Smile

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/think-carefully-which-sql-server-you-wan

Post #1381558

« Prev Topic | Next Topic »

Permissions