Export to DBIII from SQL Server 2000 DTS package
- From: pfatcat@xxxxxxxxx
- Date: 18 Jan 2007 14:05:03 -0800
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
.
- Prev by Date: Re: Need help with DTS job steps (sysjobsteps)
- Next by Date: RE: After install SQLServer2005_DTS.msi
- Previous by thread: Re: Need help with DTS job steps (sysjobsteps)
- Next by thread: RE: After install SQLServer2005_DTS.msi
- Index(es):
Relevant Pages
|
