The procedure kept failing with error - Invalid Object Table Name

This is because the database context is not supplied in the bcp string and it defaults to the master...

Sorry the explanation is wrong. Then the question is not properly framed. Questions should be aimed at eliciting understanding....

Even if go is not a standard tsql, then...

Sorry i disagree with the answer, unless there is an explanation for "NotGo"