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 |
|
cronid
Starting Member
26 Posts |
 Posted - 2006-08-09 : 10:08:39
|
| I'm getting the error listed below. Column 11 of a text file contains the value '05360' which I'm trying to move to the column rebate_rate, which is a decimal with a precision of 5, scale of 3. How can it overflow? It should be a string of 5 to five digits.DenError during Transformation 'DTSTransformation__8' for Row number 1. Errors encountered so far in this task: 1. Error Source: Microsoft Data Transformation Services (DTS) Data PumpError Description:TransformCopy 'DTSTransformation__8' conversion error: Destination overflowed on column pair 1 (source column 'Col011' (DBTYPE_STR), destination column 'Rebate_rate' (DBTYPE_NUMERIC)).Error Help File:sqldts80.hlpError Help Context ID:30501 B|0018|00206R102||000053700||000166470000||07052006|261860009|05360|| |C| |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-08-10 : 05:58:18
|
| Try typing "05360" into rebate_rate....using EM. See if you get the same problem. |
 |
|
|
cronid
Starting Member
26 Posts |
Posted - 2006-08-10 : 08:58:26
|
| Thanks, that worked. 05630 was also rejected. SQL Server is looking for the decimal point in the text file, ie. 05.360, not 05630.I can fix that.Den |
|
|
|
|
|
|
Destination overflowed problem