Hi

My remote server name and password is correct.I could do the same thing when i try using development server.But when i use bcp in my production server to copy data from...

Hi

My user name and password is correct.I could connect to the remote server using the same username and password.But when i try to copy data using bcp it shows the...

Hi

      It is working now .Thank you very much

Tomgy

Hi

Thank you for your reply.

I tried your solution, but i am getting following results when i select rows from #tmp table.please advice

My Statements

----------------

CREATE TABLE #tmp( XMLContainer TEXT)

INSERT #tmp

exec master.dbo.xp_cmdshell 'c:\specialticket.xml'...