Lost Connection Issues

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.
Post Reply
Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Lost Connection Issues

Post by Pinturiccio » Tue 04 Sep 2018 17:24

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.
Top
Post Reply

Return to “SSIS Data Flow Components”