Re: DTS Transform Task With Visual Foxpro

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi Karen,

I assume you're using SQL2K, and I'm sorry I don't have it installed on this
machine.

How are you connecting to your Fox tables? OLE DB? ODBC? You can get the
latest FoxPro and Visual FoxPro OLE DB data provider from
msdn.microsoft.com/vfoxpro/downloads/updates.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com


"Karen Hodge" <KarenHodge@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A7C235C0-DC16-4FEA-9C3A-A0E34161CB3D@xxxxxxxxxxxxxxxx
I want to create Transform Data Task with a VFP free table as the
destination.
The table is not in the dropdown selection. I know the table exists
because
I can see it in the folder.

I am able to add an Execute SQL Task with the same VFP Connection and
query
the missing table. I get the expected results.


.



Relevant Pages

  • Re: MS Access and ODBC/OLE DB
    ... Generally speaking, Access uses ODBC when connecting from an .mdb, ADO ... when it executes is anyone's guess since it is compiled in the ... >If it uses OLE DB, is there a need to confure OLE DB? ...
    (microsoft.public.sqlserver.odbc)
  • Re: FoxPro ODBC DSN Problem
    ... FoxPro tables is the same as any other ODBC or OLE DB compliant database. ... Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ...
    (microsoft.public.data.odbc)
  • altering .cdx indices for vfp
    ... My client has a visual foxpro app that he wants me to hook into. ... connecting to it via odbc using visual basic .net with this ... all with .cdx files. ... but not with odbc. ...
    (microsoft.public.dotnet.languages.vb)
  • altering .cdx indices with vfp tables
    ... My client has a visual foxpro app that he wants me to hook into. ... connecting to it via odbc using visual basic .net with this ... all with .cdx files. ... but not with odbc. ...
    (microsoft.public.fox.helpwanted)
  • altering .cdx files for visual foxpro
    ... My client has a visual foxpro app that he wants me to hook into. ... connecting to it via odbc with this connectionstring: ... all with .cdx files. ... but not with odbc. ...
    (microsoft.public.dotnet.framework.adonet)