Kbase P41172: Cannot transfer a large decimal from Progress DB to SQL Server using DTS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Cannot transfer data from Progress DB to SQL Server using DTS
Large decimal number
"Numeric overflow. Error in column n"
CAUSE:
DTS allows maximum 16 digits on the left side of the decimal point.
FIX:
Column can be transferred by casting it to varchar.