Perfect that helps, Thanks everyone for looking into this,

It is resolved and I am closing this.

Resolution :

It got resolved by setting the property

"Retain null values from the source as null values in the data flow"

to true in the flat file source.