April 12, 2004 at 4:25 pm
The company I work for has a number of access databases that track QC and production information. We are moving them to a new SQL server everything goes smoothly except for the date time fields. Is there a good articles or reference I could get to learn more about this problem. I have a two-week time frame and I really don’t know the information to post on this forum so you can help me out. I have done some querying in t-sql but DTS is new to me.
Cory Lee McRae
This is the error :
Error at Destination for Row number 279, Errors encountered so far in this task: 1.
Insert error, column 33 (‘PostCureDate’, DBTYPE_DBTIMESTAMP), status 6: data overflow Invalid character value for cast specification
April 13, 2004 at 1:11 am
Not that I know too much about DTS. But this looks like a problem with your original data like the error message says. You might want to take a look at the row that caused the error and correct it or post the results you find here again.
Useful might also be SQLDTS.com
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 13, 2004 at 10:22 am
Thanks for the input I am looking in to that column now. Is there a way to check for data conformity some query maybe? This is not a huge database, but there over a 1000 records and looking at each individual one could get pretty taxing. I am looking for things myself but I am pretty clueless on DTS things.
Cory McRae
April 13, 2004 at 1:18 pm
So looking further that error means that a date is out of range. Meaning not between 1/1/1753 to Dec. 31, 9999
Or for small date time not between Jan. 1, 1900 to June 6, 2079
I ran a query for all dates not in that range and found a few that had been miss typed I fixed them and now it works fine
Cory McRae
Thanks for the help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply