No it was simply typed in no expression -- Thanks for your response but I just resolved the issue by creating a new connection manager object. I guess I still don't know how to adjust the metadata if that is the issue but as most projects I am on a deadline so needed to move on. If you know how to do this I would appreciate your response.
Thanks,