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

Vikash Kamat 0 Reputation points
2024-04-03T06:27:57.8566667+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
492 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,506 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.