Post reply

Bulk Copy

  • August 30, 2004 at 3:45 am

    #59310

    Dear Ganesh

    Thank you very much.It is working fine

    Regards

    Tomgy

  • August 30, 2004 at 4:25 am

    #521022

    Yes. Provided the date file location is shared.

    exec master..xp_cmdshell 'bcp "select * from Northwind..Customers" queryout "\\Ec2pin124241\CallDTS\Customers.txt" /c /t"," /Usa /P /S EC2PIN124241\EC2PIN124241'

    Hope this suffice your query.

    Thanks,

    Ganesh

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply