Re: Cannot export data to .dbf file
- From: "Cindy Winegarden" <cindy_winegarden@xxxxxxx>
- Date: Mon, 8 May 2006 17:59:37 -0400
Hi Carl,
You're working with a dBase 3 driver and a FoxPro table? Are you wanting the
resulting table to be a dBase 3 DBF or a FoxPro DBF? Have you considered
using the FoxPro and Visual FoxPro ODBC drivers, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates/odbc or the FoxPro and Visual
FoxPro OLE DB data provider, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates ?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
"Carl Henthorn" <CarlHenthorn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:048B6C9F-6F38-44AB-9A33-175CEC15BBFD@xxxxxxxxxxxxxxxx
I have a package that is supposed to export data to a foxpro.dbf file.
There
is one step that creates the export file by using the dBase 3 odbc
connector
and uses the sql "Create table" statment to create the file. I cannot get
this to work. The error I get is "Unexpected error from external database
driver(9492)".
Googling this error has not turned up any answers. I tried removing that
step and instead having a data pump export directly to this file, but that
fails as well.
Any ideas on what I am doing wrong?
ps. I set access levels on the dest folder to full control to everyone.
Thanks in advance!!
.
- Prev by Date: Re: SSIS as part of scheduled job fails
- Next by Date: Integration service package execution error.
- Previous by thread: Re: Trying to call to stored proc from ASP?
- Next by thread: Integration service package execution error.
- Index(es):
Relevant Pages
|
