?
Solved

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

Posted on 2011-09-07
5
Medium Priority
?
1,039 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
  • 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 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

616 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