SSIS package running fine in visual studio but when trying to run same package its failing.

Vikash Kamat 0

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

Yitzhak Khabinsky 25,116 Reputation points

2024-04-03T12:40:54.67+00:00

@Vikash Kamat,

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).
Vikash Kamat 0 Reputation points

2024-04-04T07:32:17.8633333+00:00

Thanks Yitzhak for your response, Visual Fox Pro OLEDB drivers already installed at both development and production servers.
Yitzhak Khabinsky 25,116 Reputation points

2024-04-04T19:09:05.6633333+00:00
@Vikash Kamat,

Please edit your question, and add the following:

A screen shot with the error.

To check what OLEDB Providers are installed, issue the following command in the SSMS on the SSIS run-time server, and share its outcome:

EXEC master.sys.sp_enum_oledb_providers;
Vikash Kamat 0 Reputation points

2024-04-05T06:27:58.4066667+00:00

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
Yitzhak Khabinsky 25,116 Reputation points

2024-04-05T13:25:07.7633333+00:00

@Vikash Kamat,

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.
Vikash Kamat 0 Reputation points

2024-04-09T10:26:59.8766667+00:00

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

1 answer

ZoeHui-MSFT 33,296 Reputation points

2024-04-05T01:21:57.1133333+00:00

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.
Please sign in to rate this answer.
Yitzhak Khabinsky 25,116 Reputation points

2024-04-05T13:23:01.3366667+00:00

@ZoeHui-MSFT,

Microsoft ACE OLEDB Provider has nothing to do with the Visual FoxPro.
Sign in to comment