Error on sink data to MySQL - communications link failure
I've got a Pipeline with some Data Flow activities that runs in parallel.
I've got the error on last night's execution and I'd like some help to understand why and how to prevent it from happenning.
Job failed due to reason: at Sink 'EnviaFerias': Communications link failure The last packet successfully received from the server was 7,905,186 milliseconds ago. The last packet sent successfully to the server was 7,905,186 milliseconds ago."
All dataflows have the same standard:
- Source Activity: Get data from a SQL Server dataset using a query
- Order Activity: define received data order using column RegisterDate
- AlterRow Activity: to INSERT, UPDATE or DELETE data based on key column ID
- Sink Acitivy: to sendo transformed data into MySQL
Error happened on marked line below.
All other dataflows runned successfully.
Also, would it be possible to run only those that failed instead of the entirely Pipeline?
Best Regards.