I'm trying to sweep boss a "pipe" down and around a cylindrical surface that would be merged together as one casted part. I'm having a lot of trouble getting it to work.

Steps I've tried

1.wrap feature for path and guides

2.convert to 3d sketch (sweep wouldn't follow the wrap scribe but once it does follow its all twisted and looks weird)

3.used a loft and 4 guide curves built from wrap feature and 3d sketch on two separate cylinder bodies (this got the closest but was leaving weird artifacts)

4.I've tried building the cylinder first, the pipe first, multibody then merging, etc. cant get anything to work

5.My last attempt i tried sweeping the pipe first then was going to cut extrude the outer curve 

Here is the SLDWRKs file 

Thanks for the help