te data in just one columnBulk Insert from text File
-
I am trying to bulk insert data from a text file to a temp table. The bulk insert is unable to recognise the linefedd character and tries to insert complete data in one column. Can anyone help me solve this problem.
-
I am trying to bulk insert data from a text file to a temp table. The bulk insert is unable to recognise the linefedd character and tries to insert complete data in one column. Can anyone help me solve this problem.
Try and alter the line break from {CR}{LF} to {CR} or {LR}. Some Unix files can have strange formating for new carriage returns. Failing that if you can use anything as row delimiter such as |||@@@|||, as long as you can alter the orginal text file.
-
Try and alter the line break from {CR}{LF} to {CR} or {LR}. Some Unix files can have strange formating for new carriage returns. Failing that if you can use anything as row delimiter such as |||@@@|||, as long as you can alter the orginal text file.
Thanks for ths reply, but none of them worked. It works when downloaded through command prompt ftp command, but not when downloaded using our ftp code written in VB.net.