I'm not sure here but I think the string is too long. Maybe not the best solution but try to remove a couple of zeros at the end.

convert(datetime,substring('5/27/2013 16:42:37.490000',0,23))

In ssis there is also a transformation named Data Conversion that you could try instead of a Derived Column.