Solved

using SSIS 2005, how do you export a table to a DBF file?

Posted on 2011-09-07
5
939 Views
Last Modified: 2012-06-27
I've been searching and having trouble finding a solution for this.  Not sure why it's not as sample as exporting to an Excel file, but....

Using SQL 2005 integration services, how can you export a SQL table directly to a DBF file.
Thanks in advance.
0
Comment
Question by:CADAdmin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:carsRST
ID: 36496865
You'll need to download the driver for dbase to your computer.  

Then follow these steps.

http://msdn.microsoft.com/en-us/library/aa337084.aspx
0
 

Author Comment

by:CADAdmin
ID: 36498530

To further explain, I would like to export a SQL 2005 table to create a new .DBF file.

I already have the driver installed, and I can connect to a .DBF file that already exists.

Currently, I'm exporting data from SQL 2005 to a dummy MS Access DB to create the table inside the DB.  I then export the table from MS Access to .DBF.  I just wanted to ommit this middle step of exporting to MS Access first, then to DBF.  Is this possible in SSIS?  Thanks.
0
 
LVL 16

Accepted Solution

by:
carsRST earned 500 total points
ID: 36498941
Yeah, see the link.  

I followed the exact instructions and was able to export to DBF.

What I did was first export to a DBF file (from Access) and then walked through the instructions to create a DBF connection.  (note section on file path and where file name goes)

In SSIS, i then created dataflow task, created a source to SQL Server and a destination to my DBF files.  I then ran the process and received no errors.

If you need to clean the table first before export, just use an Execute SQL Task and run a delete statement.




0
 
LVL 16

Expert Comment

by:carsRST
ID: 36498985
Just to clarify, I used Access JUST  to create the DBF file, since I didn't currently have one.

After that, i was able to export directly from SQL Server to DBF without any issues.

But pay particular attention to the steps 3 and 4 on that link.  They're critical to follow exactly.
0
 

Author Closing Comment

by:CADAdmin
ID: 36499194
Thanks.
0

Featured Post

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question