Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Importing from DBF Expand / Collapse
Author
Message
Posted Monday, November 5, 2012 9:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:53 AM
Points: 10, Visits: 24
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
Posted Monday, November 5, 2012 10:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
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
Posted Monday, November 5, 2012 10:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:53 AM
Points: 10, Visits: 24
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
Posted Monday, November 5, 2012 10:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
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
Posted Tuesday, November 6, 2012 7:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:53 AM
Points: 10, Visits: 24
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
Post #1381558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse