Using Replace function in Derived Column -- SSIS
Posted on 2013-06-10
I am trying to remove leading zeroes off of a source column when loading the data to a sql server table. I have to handle this in SSIS and hence using derived column transformation.
Initially I tried this:
But, the above expression is removing all the zeroes from the record no matter where the zero is.
For Example: If I have "0012052400", it is transforming it into "12524"
I tried doing this:
This is giving me correct results, But if I get any text in that column then my package will fail. As the Column 1 has text and it cannot be converted to INT.
Please help me with a work around for this.
Thanks in advance!