Remove ASCII character via SSIS

[NewbieWithSQL]

I'm trying to remove an ASCII character from a flat file. I have the flat file source task pulling the file and when I look at the data, it seems that there is either a carriange return or line feed at the beginning of one of the fields.

Can I use the Derived Column task to remove it and which syntax would I use.

Thanks

 

[fredericofonseca]

if it is indeed a CR or a LF, and if that one is on the last or first field of a record then I would say your file definition needs to be changed to match the input file.

note that if you are receiving that file from another system it is possible that the file definition is "record delimiter CR+LF"
Also if the original file is set to "CR" for example, and if you manually created a test file with a editor that created that file as "CR+LF" you would have that issue.

And.. if you have a source file defined as "LF" and you used ftp to get that file from a remote system, ftp may have added a CR to the file as part of the conversion process.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886