skb 44459 (3/21/2013)
Yes In the code i am appending the Servername but i get same result with or without the ServerName.
Have you modified SSMS so you can see the entire output showing what xp_cmdshell would run? i.e. the entire contents of the variable?
WHen you can, copy the bcp command line and run it directly from a cmd shell prompt. Let us know the output.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato