SSIS can not connect to Excel source

Sunny 60 Reputation points
2023-11-29T08:51:11.6766667+00:00

I created a package to load data from Excel to sql table, when i run it, it thrown error.

Acquireconnection method called to the connection manager xxx failed with error code 0xC0209309 balabal

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

Accepted answer
  1. ZoeHui-MSFT 35,226 Reputation points
    2023-11-29T09:27:46.01+00:00

    Hi @Sunny,

    It seems like a 32bit vs 64bit issue. You may try with below methods.

    (1) Run package in 32 bit in SSIS

    Try running the package in 32-bit mode:

    GoTo Project properties >> Debugging >> Run64BitRuntime = False

    (2) Install both AccessDatabaseEngine 32bit and 64bit

    Check: How to install 64-bit Microsoft Database Drivers alongside 32-bit Microsoft Office

    Regards´╝î

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 43,161 Reputation points
    2023-11-29T09:04:34.7633333+00:00

    The error code is more or less useless, we need "balabal" im detail.

    And some more detailed information, too: Executed in SSDT or as job, etc.

    0 comments No comments