I ran into the same error, but I was trying to do a SELECT...INTO in a linked server. I had to script the table on the target DB, then run an INSERT...SELECT. A pain, but it got the job done.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices