Identity coloumn will be always auto gaenerated no need to insert the data for those column .

I think we can also use derived column transformation and use the datediff() function and system time

to get the age .

Thanks vishal,its realy heplful .

-nikethan

Thanks vishal,its realy heplful .

-nikethan

Further i am planing to log the error , so raise error method will not be much helpful i think so .........