September 24, 2002 at 10:47 am
While attempting to copy a varchar value of 9999555179 to another varchar field during a DTS process, I get the following error:
The conversion of the varchar value '9999555179' overflowed an int column, maximum integer value exceeded.
This error would make sense if I was using an int column anywhere in my tables, but I'm not. I've tried casting and converting the column in my source query, as well as using CStr(column) in an ActiveX transform, but to no avail. Any idea why this would be happening? Thanks.
September 24, 2002 at 4:57 pm
Resolved. The message was due to an error in a SQL query string in an ADO connection. I left off the single quotes in the WHERE clause. SQL Server converted the passed value automatically in my original test data, but failed when hitting the 9999555179 value. Not that strange an error after all...<lame sheepish grin here>.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply