Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Thank you for the provided information. On the Devart connection side you can only try increasing Connection Timeout and Default Command Timeout values. However, if there are large data in your database, for example, types like BLOB or LONGTEXT are used, you may also need to increase values for net_write_timeout and net_read_timeout on the server side. Regardless of the Connection Timeout and Default Command Timeout values, the server may break the connection after reaching timeouts, specified in net_write_timeout and net_read_timeout.