-
Adding Leading 0's in SSIS through Expression
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|