Home Forums Data Warehousing Data Transformation Services (DTS) TRANSFORMING DATE USING DTS RE: TRANSFORMING DATE USING DTS
Alan Spillert
SSCommitted
Points: 1964
More actions
July 30, 2003 at 7:06 am
#467720
I would suggest maintaining the date-time column, and creating a set of computed columns which return the values using the DATEPART function. This will allow you to do date arithmetic in the future, as well as view the attributes you need now.