SSDT(2017) how to set Access DataBase engine64

苏川 梁 46 Reputation points
2022-04-12T02:20:09.483+00:00

I used SSDT to create an SSIS project, but an error occurred when reading excel when running, and it is normal to replace it with a 32-bit database engine, so I would like to ask, where can I set the database engine in SSDT, or I only have this one Can use 32-bit database engine.

Thanks.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 41,491 Reputation points
    2022-04-12T02:37:03.58+00:00

    Hi @63642299,

    You may use Run64BitRuntime.

    Project Properties-->Select Configuration Properties-->Select Debugging-->Select Debug Options-->Set Run64BitRuntime to True.

    192142-image.png

    About the 32bit and 64bit for Microsoft.ACE.OLEDB Provider.

    You may also refer to installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.