This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 88%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Dear Team,
I want to do simple copy activity using Data flow task in SSIS package, in which my source is a old database using visual fox bro and tables are saved as dbf files .
I am using OLE DB connector for visual fox pro to get data from source dbf files and copying it in SQL server table using OLE DB connector for SQL server.
This is working fine and running as per expectation but when i am trying to run in using SSIS job agent , it is giving error that requested OLE DB provider is not registered .if 64-bit is not installed run package in 32-bit mode.
After changing at project configuration properties in debugging from 64 bit to False and at Job level , enabling 32 bit also . It is not working .
Then its ask to change to 64 bit but job fails in both the cases.
Please advise how to sort this out.
Thanks and Regards
Vikash
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
SSIS doesn't have Visual Fox Pro OLEDB drivers out-of-the-box. It seems that you need to install that driver on the SSIS run-time server, not just on your developer workstation (PC).
Thanks Yitzhak for your response, Visual Fox Pro OLEDB drivers already installed at both development and production servers.
Please edit your question, and add the following:
EXEC master.sys.sp_enum_oledb_providers;
Hello Yitzhak,
Thanks for your response. i have attached the error message from SSISDB deployed project from where its start failing .
Also, i am adding list of OLEDB driver installed on the SSIS runtime server
Thanks and Regards
Vikashlist of drivers.PNG
So, the screen shot provided reveals that the 64-bit FoxPro OLEDB Provider is not installed on the SSIS run-time server.
I hope you know what to do now.
Hello Yitzhak,
Thanks for your response.
Actually 64-bit FoxPro OLEDB Provider installed but window is not registering it , even i have tried force registration with windows but that is also not working .
Regards
Vikash
Hi @Vikash Kamat,
Please try to install both 32bit and 64bit mode OLE DB provider.
Check this link Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Microsoft ACE OLEDB Provider has nothing to do with the Visual FoxPro.