SSIS Difference Between DT_DATE, DT_DBDATE, and DT_DBTIMESTAMP

Useful short reference on the difference between DT_DATE, DT_DBDATE and DT_DBTIMESTAMP.  In short, use DT_DATE to omit time, DT_DBDATE if you want time but are not worried about time precision, DT_DBTIMESTAMP if you do want time precision, or if you want a method that uses ISO...
Send