i just tried this statement in SSIS and SSMS

update dbo.emDetail

set dateYear = DATEPART("year",'datestamp')

and am getting the following error

Conversion failed when converting datetime from character string