I guess that would be possible if I am using just the view as my source .. by my source query is kinda complicated. the view gets joined with another...

found it.. it is getting converted to int in the view. so removed the cast in the view and let it flow as varchar.. and then in the derived column...

Thanks! I was trying to do that but I am not able to figure out one thing. I have a column xyz which is defined as char in all the...

Did u try deleting the column which is not in order and inserting it before/after in the advanced editor window.. it worked for me as i had few columns. But...