Hi,

I finally got this DTS thing to work except that when the records are
written to the specified text file there is a blank line/carriage return in
between each record:

Record 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Record 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Record 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

is there any way to get rid of that space?

Thanks!

Mitch

What do you have for your file type and row delimiter in the properties of
you export connection?

Rick

"mitch" <mitch_001 (AT) REMOVEyahoo (DOT) com> wrote

I tried every combination and these two produced the best results:

Fixed
OEM
CR/LF

and

Fixed
UniCODE
CR/LF

Thanks for taking a look at this.

Mitch




"Rick Gittins" <rgittins (AT) dungarvin (DOT) com> wrote

Problem solved!

Very strange, but the problem was that although I was not calling up every
field in the table, the fields that were not being used and were just NULL
were causing a bunch of extra characters that were forcing a line break.

I removed those fields we would never use and it works fine.

I thought I would post this just in case someone else runs into this
someday.

Mitch


"mitch" <mitch_001 (AT) REMOVEyahoo (DOT) com> wrote