Hi, i am pull the data from oracle to flatfile. i have one date column like Birthdate column in oracle table. i want calculate the age in derived column like ORACLE FILED - GETDATE(), But orcale date filed is different format how can i caluculate the age. plz let me know

muppasuresh, importing dates from Oracle can be a problem, because oracle stores datetime values with more precision than SQL. I think your problem might be due to that. if so, see the below link about importing oracle timestamp fields (if it's stored in oracle as a timestamp) http://subhashsubramanyam.blogspot.com/2007/07/populating-oracle-timestamp-values-into.htmlTom Overton

put a data viewer right after the source for oracle and let us know the format of date values, then we can help you in expression to find the age based on date field.http://www.rad.pasfu.com

Hi suresh, Just my 2cents here : Oracle might have some date format conversion functions. If so, try to get the date in required format(using a stored procedure or sql statement) and then use it in the derived transformation or Execute SQL Task.Happy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/

muppasuresh, importing dates from Oracle can be a problem, because oracle stores datetime values with more precision than SQL. I think your problem might be due to that. if so, see the below link about importing oracle timestamp fields (if it's stored in oracle as a timestamp) http://subhashsubramanyam.blogspot.com/2007/07/populating-oracle-timestamp-values-into.htmlTom Overton

put a data viewer right after the source for oracle and let us know the format of date values, then we can help you in expression to find the age based on date field.http://www.rad.pasfu.com

Hi suresh, Just my 2cents here : Oracle might have some date format conversion functions. If so, try to get the date in required format(using a stored procedure or sql statement) and then use it in the derived transformation or Execute SQL Task.Happy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/