DTS Package Import CR/LF

#1

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?

#2

The only way I can think of dealing with this, is to set your line delimiter
to
LF and use an active x script to remove any chr(10) values from the last
field of each record.

HTH

"Tim Almond" <anon (AT) anon (DOT) co.uk> wrote

Quote:

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Package Import CR/LF

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Package Import CR/LF - 09-18-2003 , 07:03 AM

Re: DTS Package Import CR/LF - 09-18-2003 , 10:58 AM