Here's a good one - Operand type clash: int is incompatible with date.
It appears, although I have not fully confirmed, that SSIS does not play well with the new SQL Server DATE data type.
I ran into this issue when calling a stored procedure from an OLE DB Command transformation. The stored procedure had a parameter of data type DATE.
While not entirely satisfying, the quick fix for this is to change the parameter data type to DATETIME.
An issue was opened with Microsoft but they state they have not been able to reproduce the error.