Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS DATEPART derived column RE: SSIS DATEPART derived column
Phil Parkin
SSC Guru
Points: 247210
More actions
January 15, 2010 at 8:46 am
#1104255
Is DateStamp a column name in emDetail?
If so, your syntax is going to be more like this:
update dbo.emDetail
set dateYear = DATEPART('year',datestamp)
Remember single quotes for literals in T-SQL.