Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
murrayb3024
Yak Posting Veteran
79 Posts |
 Posted - 2005-11-30 : 12:53:15
|
| I built a dts package to import multiple Microsoft Access tables. In each of these tables is multiple dates. Most of them import without problem. But I have 5 tables with 1 date each that are failing. The Access tables are all set up the same way as are the SQL Tables. The error I am getting is:status 6: Data overflow.Invalid character value for cast specificationWhy am I only getting this on certain fields and not all of them? I looked at the data in the Access and all the dates look the same. Anything else I can check? I tried running scripts with CDate and IsDate in the dts package and it still fails. Any other ideas? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-11-30 : 16:54:57
|
| Perhaps you could try formatting the source dates as strings then getting the DTS package to parse them into DateTime's. I've struck a similar problem to this where the Access dates were dodgy - e.g. 1-Jan-00 could have been 1-Jan-0000 (i.e. 2000 years out). You don't see this normally when you view the table in Access. You could try this also - query the tables from within Access and show the dates as Format(<YourDateField>, "dd-mmm-yyyy hh:mm:ss").HTH,Tim |
 |
|
|
|
|
|
DTS Package to import access data..