Kbase P145973: Getting error trying to copy data from Progress Database to MS SQL Server Database using Ms SQL Serv
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/11/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting error trying to copy data from Progress Database to MS SQL Server Database using Ms SQL Server DTS package
The number of failing rows exceeds the maximum specified.
TransformCopy 'DTDTransformation_16' conversation error: Conversation invalid for datatypes on column pair 1 (source column 'pro_element("progress_date_field",1,1)' (dbtype_str) '<mapped MS SQL Server datetime field>' (DBTYPE_DBTIMESTAMP)).
FACT(s) (Environment):
Using Microsoft DTS package to copy data from Progress database to MS SQL Server
MERANT 5.1 32-BIT SQL-92 driver
Created an identical database as progress to the MS SQL Server using the Progress PRO/SQL tool's CREATE TABLE utility
Progress 9.x
Progress 9.1E04 Service Pack
All Supported Operating Systems
CAUSE:
Progress date data type is not the same as the MS SQL Server datetime data type
FIX:
In order to workaround the issue, use CAST() function on the custom SQL-92 SQL to change the date data type to CHAR(30) as well as change the datetime data type on the MS SQL Server database to varchar(30).
For a field without extent:
CAST(myProgressDateField AS CHAR(30)) AS myProgressDateField
For a field with extent:
CAST(PRO_ELEMENT("myProgress_table"."myProgress_dateField",1,1) AS CHAR(30) ) AS date1