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.