I was trying to migrate a table from one database to another using a script. It shouldn’t have been too complicated. It probably wouldn’t be for someone who has done it before. I had a problem getting some of the fields to copy over. They all involved date/time information. My search led me to this interesting post:
SSIS: What’s the difference between DT_DATE and DT_DBTIMESTAMP
Database people don’t generally like date values too much. They’re too fiddly. There’s god-knows-how-many ways of representing them…and don’t even get me started on regional date settings!!
SSIS Junkie : SSIS: What’s the difference between DT_DATE and DT_DBTIMESTAMP