Thanks John, I.Ronnoco & last but not least, Divya's website on date calculations in sql for your help in pointing me in the right direction ... for anyone with the...

Thanks everyone for suggestions ... they have given me a couple of ideas as to how to proceed within BIDS SSIS on this issue ... will provide an...

Thanks John ... I'll try out as suggested and see how it goes ...

Thanks for a very interesting tip ... problem I have though is while my expression provides me with a previous date ... it fails when moving into another month for...