DSXchange

Thank you Craig for your advice. This makes sense. Much appreciated.

Hello, I handled the description field at the extract job level by adding the convert function in the transform stage Convert(CHAR(13):CHAR(10),"",SRC01_TO_TFM01.OLADES). It worked like a charm eliminating CR LF characters. Will be marking this post as resolved. Thank you again for everyon...

Thank you Craig, Andy, rav.wurlod for your replies. About the production statement, yes it is also happening in DEV and QA. Sorry for the confusion. About all the solutions, I meant to say the different 'functions' I tried with no success. Forgive my frenglish! ;-) About the error message, this is w...

Hello all DSXchange members, Need help with removing CR LR characters in a sequential file causing our production job to fail. I have looked at the many posts in the forum and used all the different solutions proposed ... but they all failed. I have created a sequential file from an ODBC extract. On...