TIL: RetainSameConnection

I recently had to debug a co-worker's SSIS package, trying to figure out why it wasn't working quite right.  We have a sharded infrastructure, meaning that our customers' data is split out among a number of servers with equivalent schemas.  For this particular package, we wanted to, for each customer, get the relevant data from…