Thursday, July 05, 2007
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
© Copyright 2009 Michael Phillips
Theme design by
Bryan Bell
newtelligence dasBlog 1.9.7174.0
| Page rendered at Tuesday, January 06, 2009 3:14:17 AM (Central Standard Time, UTC-06:00)
Pick a theme: