Look at the data type for the SSIS component (source output) to see the data type. If you just used the default it probably read the xls data type as int and therefore is dropping the leading zero. Change this components data type to varchar() like the SQL table data type and that should correct it.