I tried to wrap the code in EXIT() and run it but the error still persists.

@CMDSTR looks follows after wrapping it in EXIT() :

osql -S MYSERVER -E -d MYDB...

Hi Luke,

Thanks for replying.

Adding the servers as linked server is not an option here as the server names will be kept on changing in the tables on frequent basis....