Hi
I tried to import data from flat file using DTS it works
fine. Field delimiter is comma and Row Terminator is {LF}.
But I don't know How to mention Row Terminator For Line
Feed in BCP or Bulk Copy.Please Help me.

Thanks
Kishore

Hi Kishore,

The Row Limiter for Line feed should be either CR/LF OR LF.
You can pass it using the -r Parameter of the BCP command.

HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Ashish,
it is giving error unexpected eof encountered in bcp data-
file. I used row terminator -r with LF .

Thanks,
Ksihore

Hi Kishore,

Does it ask you Qs like the "Data Type", "Prefix Length", "Length of
Field", "Field Terminator" for each field value in the Text file.

I tried creating a text file and it asked me the value for the above
Variables for all the Fields and for the last field the "Field Terminator"
was "LF"

Does it give you the error before even asking these Qs ?

Have you tried opening the file in notepad ?

Just try importing the Data in an Excel Worksheet and check if it is able
to import the data in excel worksheet.

HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.