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

Question

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

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

Phil Parkin SSC Guru Points: 247180 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?

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")