SSIS - How to easily parse yyyy-mm-dd hh:mm:ss a.m. format

I need to parse a date like "22/06/2010 3:21:31 p.m.开发者_开发技巧" in SSIS in a data flow.

Cast(DT_DBTIMESTAMP ) does not work at this is does not handle this format.

What is the easiest way that I can do this?

You appear to have a couple of problems. First, I don't think your date format is acceptable. Can you change the p.m. to pm (remove the periods)?

The other possible problem is your SSIS expression. The SSIS expression syntax would be

(DT_DBTIMESTAMP)NameOfVariable