I opened up the transmission and found a couple things that surprised me.

1) Of all the connetions for the wire harness, only two of them were not broken and were locked into place, I think there were 4 other connections where the locking mechanism was broken and the pieces not anywhere to be found.

2) I found a bolt just sitting in there, not at all tightened, just loose and would have fallen out if the housing was not there.

This transmission was serviced by AAMCO a few years ago (about 32K miles ago) and the car has been sitting in the garage for 2 years. Does this surprise anyone? Should I be pissed? Is this the cause of the P0742 codes I was getting? Do I need to replace the wire harness (my gut says yes).