Hi,

I know its too late response:-) But I have seen this post for the first time.

What I understood is that he wish to convert customer no to INT, in derived column instead of using replace column option to convert data type, use <add column> and then apply type cast DT_I8.

I hope this will help you.