DSXchange

What if you write a job with source from the ODBC stage?

Did you search? There are loads of relating post.

Try to display the original value you wish to transform.

Can you view the data ?

What kind of lookup is it?

Are you able to view data?

Did you trying bouncing DS ?

In pseudocode.....

If you find that 'n'th char is where you need to break, do it like I will leave it to you to derive the value of 'n' and 'newlineChar'

or easier still, convert the req char to newline.

What does your webconsole say?

The name of the stage appear to imply a "Read" rather than "Write".

Is this different from your previous query?

Can you post the SQL.

What if you remove the CREATE INDEX command ?

What if you remove the CREATE INDEX command ?

Did you install any dlls or upgrade your client windows ?

Is it an interview Q ?

DSExecute() ?

Remember seeing a similar post with issue in control file size thus resulting in truncation of control file.

That was when there were 400+ fields in the table.