I am executing a Query on a MySql server, using the Execute Query activity. The Query is expected to take up to a minute. Every other time, the Query is failing due to a timeout on the connection, with the following message:
Could not kill query, aborting connection. Exception was Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Execute query : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How do I go about increasing the timeout period?