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

good to know. i was beating my head against the desk the last couple of days.

i don't supposed i could trouble you for the sql command to...

yes. update same table. i currently have datestamp (populated), dateYear (blank), dateMonth (blank) (blank), dateDay (blank). i want to extract the different blank parts from the datestamp....

i think that everything is mapped correctly. i even stripped everything down to be as simple as i could make it. it is still trying to add new...