After allot of tinkering I finally figured out how to attach the object and correct its rotation.
The main thing that was tripping me up was the Attach Type setting in Attach To method.
