'What is the maximum buffer size of data transformation in ssis?

I am currently trying to load 189 Mb data from an Excel source. However I am getting the following error :

TITLE: Microsoft Visual Studio

Could not retrieve the table information for the connection manager 'Excel Connection Manager'.

Failed to connect to the source using the connection manager 'Excel Connection Manager'
ssisvisual-studio-2019


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions