Hi All,

Issue seems to be simple - but i am trying too hard to find a solution for this .. any help would be greatly appreciated.

I am trying to add leading 0's in my destination table --> I get data from csv file and the destination is table.

I used to derived columns to change the column for example I have a "Record Type" which has input 1 and when it is loaded in the table it has to be "01". I used derived columns and gave the following expression:

(DT_WSTR,2)(RIGHT("00" + (DT_WSTR,2)[Record Type],2))

I also tried using Replicate with other functions - but i am not getting the desired result.

Note: Data type of "Record Type" Which comes has an input is DT_I2.

Thanks in advance.

Regards,
varun