no leading zero in hours h:mm:ss time format to convert to seconds in a derived column in SSIS
a source flat file has duration columns in :00:00 format as well as 0:00:00 format. Trying to convert to seconds when there’s no leading zeros in the hours. Sample of the Source file when viewed in notepad++
enter image description here](https://i.sstatic.net/62SvtuBM.png)