Sorry about the comment lines. I already ran that before (and it succeeded), I just forgot to take them out when i posted to the forums.
I can pull data from ServerB to my Server from within a query without any problems.
What I'm trying to figure out is why i'm getting this error:
Message
Executed as user: Domain\AccountA. Incorrect syntax near '-'. [SQLSTATE 42000] (Error 102). The step failed.