I also resolve my issue with bulk copy command using xp_cmdshell by adding additional option for servername -S ServerName.

Thanks for your help!

that was my typo. Row terminator is '|'

syntax I have used in my stored procedure is as below

BULK INSERT TBALE_NAME FROM '\\Server_Name\Complete_Path\FileName.txt' WITH (

FIELDTERMINATOR = '|',

ROWTERMINATOR = '|',

LASTROW = 0,TABLOCK

)

I...