Export to DBIII from SQL Server 2000 DTS package

P

pfatcat

I am having a difficult time exporting a large table in SQL server
(2GB) to a dBase DBIII .dbf file via a DTS package in SQL Server 2000.
I've looked through many articles in Google groups and elsewhere about
this and I'm still having trouble.

When I use the standard Microsoft DBIII datasource the export works
fine up until 255MB where I get the message "Cannot update; Table is
currently locked". This KB article
http://support.microsoft.com/default.aspx?scid=kb;EN-US;238431 mentions
using the Microsoft FoxPro VFP Driver to access the DBIII files which I
downloaded and installed.

In the DTS package I drop the .dbf file and then recreate it via the
standard DBIII datasource.

I created a new datasource using the VFP driver and selected Free Table
Directory and checked/unchecked the Null option but am unable to
populate the .dbf file. I am getting "Destination does not allow null
on column pair one" error during export.

If anyone has exported/imported to a DBIII file before via the
Microsoft FoxPro VFP Driver I would greatly appreciate some advice.

Thanks,
pc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I automatically export a table to a dbiii file from Access. 2
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Import MS VisualFoxPro Table into Access database 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Linking to dbIII and db IV 1
[Excel2007] How to obtain provider name for ADODB.Connection 4
Excel VBA SQL Query Filename 5
ODBC and DBF File in MS Access 8

Top