Thank you!

In regard to Incorrect syntax near '.':

Please make sure you're enclosing the entire table name in delimited identifiers - use quotation marks or brackets: "Person.Person" (the same measures required as I commented earlier).

And yes, you need to connect to the 'source' database this table belongs to (AdventureWorks2008R2 in this case).