So just to close this thread out... 
I gave up on linked server under the premise that SSIS would probably be a better way to go about doing what i need to do. So long as i manually build the query i can get mappings to set column types etc just fine. Go figure.