A week ago I was using SQL Server 2008 Express and the DTSWIZARD was working fine when I selected the Microsoft OLE DB Provider for Visual FoxPro as the data source for the import data. The wizard only allows me to RUN the import and not SAVE it saying I
needed to upgrade to Developer/Enterprise edition of the server to be able to save the attributes of the import (for reuse).
So, I downloaded SQL Server 2008 R2 Enterprise as an MSDNAA (faculty) person. I installed both R2 Enterprise and R2 Express. I don't really need Enterprise (which is good because I cannot get it to START no matter what I try...which is another issue not
related to this one I am writing about here).
I now have the version/feature for DTSWIZARD that allows me to save my import attributes (yea!)...however, the problem now is when I select the Microsoft OLE DB Provider for Visual FoxPro as the data source for the import data I get the following error message
when I click NEXT: Feature is not available (Microsoft OLE DB Provider for Visual FoxPro). If I click the Properties... button (to select the VFP database) I get this error message:
Unexpected Unrecoverable Error and the wizard quits when I click any of the 3 buttons on that pop up message.
The VFP OLE DB provider is ALIVE AND WELL (I think) on my Windows 7 Ultimate 32-bit laptop as I am
View Complete Post