Hi All
I have a ForEach Activity, that copies data from tables in MySQL Database into tables in a Data warehouse(MySQL).
And I quite often get an error which I don't understand or know how to prevent from happening again.
I usually get the error for one or two tables in the ForEach while the other tables run successfully.
Error Code: 2200
Error Message:
'Type=MySql.Data.MySqlClient.MySqlException,Message=Failed to read the result set.,Source=MySqlConnector,''Type=System.IO.IOException,Message=Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.,Source=System,''Type=System.Net.Sockets.SocketException,Message=An existing connection was forcibly closed by the remote host,Source=System,'
Please assist with an explanation and how to prevent this from happening.