TCP Provider Error/Semaphore Timeout from an SSIS Package

I had a particularly tricky case recently that took a while to track down the cause, sharing in case it helps save anyone a few weeks of thier time and thier blood pressure! Symptoms An SSIS package fails with the following error; Executing the query “Some_Query” failed with the following error: “A transport-level error has…