DTS Package Import CR/LF - 09-18-2003 , 07:03 AM
I'm having a problem where files that we import seem to sometimes have a
line that ends CRLF, and sometimes just LF.
Is there any way of building a DTS Import Task to cope with both situations?
Anyone done this?
Re: DTS Package Import CR/LF - 09-18-2003 , 10:58 AM
The only way I can think of dealing with this, is to set your line delimiter
LF and use an active x script to remove any chr(10) values from the last
field of each record.
"Tim Almond" <anon (AT) anon (DOT) co.uk> wrote