?
Solved

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

Posted on 2011-09-07
5
Medium Priority
?
970 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 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

777 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