Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP OLE driver does not see all my .dbf tables?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Divers
Thread ID:
01413813
Message ID:
01414048
Vues:
32
>>Per MS site I think I got the latest VFP Driver. They are VFP tables from a 10 year old system, I think, that
>>another wrote to scrape data from a PICK system.
>
>Check the first byte of "invisible" tables by any hex editor. It'll tell you if it's VFP table or not.
>
>>Do you know of a way to convert a T or F in a csv file just insert into a SQL2005 table ? that is where I am having the hardest time is current out put of some of these tables that contain 10% logical columns.
>
>Did you consider SSIS?
-----------------------------------------------

This is inside of an SSIS package. I can pick either target dbf or csv. teh dbf is on another server and i think there is a bad switch port between the two servers. That server with the dbf files may only be on a hub but I have never been on site. I just remote in and copy files local for me to work with.

I am doing all of the dev work at my location. I can then change the connections later.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform