I have a numeric column with the following sample values in a source flat file:
240
6
48
310
55
I would like to dump them in a table (destination) as string with the length only 3 and in the following format "xxx" .
Data in the destination column will look like this after the transformation:
240
006
048
310
055
Thanks for your help!
milton06 wrote:
I have a numeric column with the following sample values in a source flat file:
240
6
48
310
55
I would like to dump them in a table (destination) as string with the length only 3 and in the following format "xxx" .
Data in the destination column will look like this after the transformation:
240
006
048
310
055
Thanks for your help!
You'll need a derived column component for that. Here's the expression
RIGHT("000" + (DT_STR, 3, 1252)[columnname], 3)
-Jamie
|||Excellent Jamie.|||
milton06 wrote:
Excellent Jamie.
Please mark his post as the answer if that solved your problem.
Thanks,
Phil
No comments:
Post a Comment