Error: Socket hang-up error

Imports or exports that use MS SQL+ agent connections can cause socket hang-up errors. Use the following steps to resolve socket hang-up errors:
  1. Verify that you are using the latest version of the agent.
  2. Verify that the machine hosting the agent remains online while the flow runs.
  3. Resolve any additional errors the flow encounters which might be caused by malformed queries or flawed data structures. Resolving these errors can solve the socket hang-up error.