Has anyone else had problems with SQL Server 2005 SSIS recognizing VFP OLEDB provider when trying to import VFP 9.0 data into SQL Server using the Import Wizard.
VFP 9.0 sp 1 Found I had to reinstall the OLEDB provider for SQL Server to see it as existing. Then when trying to run a simple import package, I get an error saying the OLEDB provider is not valid. (I guess the frustrating thing is that I really do suspect nobody really tested this.)
I have had no problem with VFP 9.0 and SQL 2000 DTS doing exactly the same thing.
Any thoughts?
TIA
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.