Thanks for your reply..

I tired using all the datetime expressions related to date with the below exprseeion in dervived column

DATEADD("WK",DATEDIFF("WK",0,date),0)- but the same query gives correct answers in sql , but shows error in SSIS dervived expressions.

I get results this way :-

Date Available in db Result Expected Result

01/11/2012 01:2803/11/2012 00:0029/10/2012 00:00

04/11/2012 19:1210/11/2012 00:0003/11/2012 00:00

06/11/2012 09:3410/11/2012 00:0003/11/2012 00:00

12/11/2012 10:5917/11/2012 00:0010/11/2012 00:00

How to achieve the expected results using dervived column in SSIS- every date available in DB, should show the starting day - Monday of that particular week.

Thanks!

Expected result-(29/10,03/11,10/11 are the starting of the week-Monday)