load multiple excel files in ssis

Shambhu Rai 876 Reputation points
2023-05-10T19:11:48.12+00:00

HI Expert,

I following the steps to load multiple files in 64 bit ssis as there many packages so can not able to change to 32 bit

https://www.mssqltips.com/sqlservertip/4165/how-to-read-data-from-multiple-excel-files-with-sql-server-integration-services/

getting error message

[Excel Source [57]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 2" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,854 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,090 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,106 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shambhu Rai 876 Reputation points
    2023-05-10T19:40:25.0966667+00:00

    one of the biggest drawback

  2. Olaf Helper 29,121 Reputation points
    2023-05-11T06:28:37.85+00:00

    many packages so can not able to change to 32 bit

    That are very less information, you should provide more.

    If you have SSIS 64 bit, then you have to install & use 64 data provider; or change the SSIS runtime to 32 bit exection, there are no other options.

    0 comments