How to remove leading zeroes from a numeric excel field in SSIS

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246993 More actions · Answer 1

uzn2010 (4/12/2016)
I'm using derived column transformation editor to remove leading zeroes from the number. Can anyone help me how to do it?

Numeric data imported from Excel does not have leading zeros (after import).

Are you importing the columns as strings?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

uzn2010 Ten Centuries Points: 1369 More actions · Answer 2

Yes, the column was string actually and using this helped that issue

REPLACE(LTRIM(REPLACE(F6,"0"," "))," ","0")