Solved

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

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now