Failed to create an IDataAdapter object

Question

I have SSIS package which consist Execute SQL Task step. Where package variable contains SQL query that executes on predefined SQL Server. There is no parameter mapping nor any more complex config. This package is configured in SQL job step to execute on every certain scheduled time.

The job keeps failing on Execute sql task randomly, since i have retry attempts configured so it works mostly on its next attempt. The error from the 'Integration service catalog' says - "Failed to create IDataAdapter object. This provider may not be fully supported with the Execute Sql Task. Error message 'Internal connection fatal error'" I need to make it work smoothly without such fatal errors.

I have already verified the SQL server connection, with the server owner and confirm the server is being used by several other process and do not have any issue to access it. It is just my SQL jobs keeps failing with this error. Any help would be appreciated.

I am using ADO.Net connection manager to connect the source SQL server. The windows server have enough memory. But RAM consumption stay between 90% to 95% on this server. I have several package configured in the same job executes step by step using same Execute SQL task config. But each time random job step fail but with the same error. I have checked Event viewer it has failure logs, but not much details it contains.