sql server (microsoft): I've been given a series of text files where all the fields are
delimted by a vertical bar, but each row takes up two rows in the text
file. So if I use any delimter like CR or LF etc., it treats each row
like two rows, since each row just finishes with a vertical bar and
then a return.

Is there any way to deal with this? I could send an example file if
required?

Thanks,
Kayda

If its a one time thing you could write a program that separates the
row so that all rows contains only one row.

Just a thought!

No, that's not an option as I'm using DTS and it is reading the files
as given to me. It reads one of these files every half hour.

Any suggestions?