What are you using linked servers for? I would recommend against using them too heavily as they can create security holes. I would recommend looking into SSIS instead.

As for your error message I would check your spelling and authorizations in both the databases and the views.

If you want to switch and do this with SSIS it is just a simple pull transaction and is very simple to implement depending on what you are trying to accomplish.