• Here is the solution with BCP command......

    !!bcp "dbo.TableName" in "D:\testData.txt" -c -Sservername -T -t"|" -r 0x0A