DT_TIME, DT_DBTIMESTAMP and DT_DBDATE

If you have been using SSIS, and have been trying to load data from Excel spreadsheets to a OLEDB or SQL Server Destination, you might encounter the following error:

".... conversion between types DT_DATE and DT_DBTIMESTAMP is not supported. "

JamieThomson provides a good discussion on the difference between the various types and possible solutions using Data Conversion component or Derived Column Component. Check out his post here.