DSXchange

Hi all,
i have a strange problem. i try to drop columns using modify stage. but strangely one of the varchar column i keep losing it values from 160 character to 100. like somebody put substring[0,100] to that column, only it isn't. anyone experience the same thing ?

check the length of that column in the modify stage output link.

checked, same 160 nullable varchar

solved by explicitly declaring the column is 160 character in specification. thanks.