Microsoft OLE DB Provider for Visual FoxPro 9.0

Im quite interested to see if any one is using Microsoft OLE DB Provider for Visual FoxPro 9.0 in an SSIS package. Is it possible to use this for free table directory like you can with the ODBC driver. ?

thanks kindly

My basic proccess is as follows: The source foxpro database has hundreds of dbf files the SSIS procress is as follows

1: Copy only required dbf files and/or matching .fpt files over to local drive on SSIS box(we only need 10 files)

use MS Visual Foxpro ODBC driver (free table option) and set up a system DSN--dataflow tabdatareader source--and away you go

Hi!

Yes, you can use the free table option with the VFP OLE DB data provider. A

typical connection string for the OLE DB data provider is

"Provider=VFPOLEDB.1;Data Source=C:\Temp\"

--

Cindy Winegarden

cindy@.cindywinegarden.com

VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx

VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

""Mr Pro Tools"@.discussions.microsoft.com"

<"=?UTF-8?B?TXIgUHJvIFRvb2xz?="@.discussions.microsoft.com> wrote in message

news:64e94200-765c-4209-afa1-a2d8bb82af1f@.discussions.microsoft.com...

Im quite interested to see if any one is using Microsoft OLE DB Provider for

Visual FoxPro 9.0 in an SSIS package. Is it possible to use this for free

table directory like you can with the ODBC driver. ? ...