This is really helpful...Thanks! But I have question,

For Footer I used the script task to get the value, but how will be mapping of the footer be done to flat...

Yes thts true they are not same,

Its just that i no more require to look for space(char(32)), only looking at first character solved ...

Thanks,

Actually I tried this

(SUBSTRING([Copy of Description],1,1) == "0" || SUBSTRING([Copy of Description],1,1) == "1" || SUBSTRING([Copy of Description],1,1) == "2" || SUBSTRING([Copy of Description],1,1) == "3" || SUBSTRING([Copy of...