Solved

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

Posted on 2011-09-07
5
904 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 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Compare data between two databases 16 110
CREATE DATABASE ENCRYPTION KEY 1 72
get most recent and second most recent date in SQL Server 24 98
Sql query 107 73
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

837 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