Warnings in ODBC Connector Stage when Table Action = APPEND

[Ankur_KapoorUK]

Hi ,

In a jon I am try to populate Oracle table BY a source dataset with RCP Enabled.

In ODBC Connector Stage , Table Action = CREATE OR REPLACE then no warning is coming up.

bUT Table Action = APPEND then the mentioned warning is coming up :p-

TgtCDLTblODBC: The length of VARCHAR column STAT cannot be validated because the database column is WVARCHAR and character set conversion is involved. Inadequate column lengths can lead to data truncation or unexpected errors.

Please note source STAT Column is of Varchar type.


Kindly provide the inputs regarding it

[Sreenivasulu]

Instead of 'typing' the error mesage kindly can you cut an paste the appropriate error message .



Regards
Sreeni

[kamesh_sk]

HI,

Did you find a solution to this problem.IAm also facing an similar problem with my jobs.
Can you kinldy post your observations.

Thanks
Kamesh

[kumar_s]

Is that column length more than 255?
When you let to Create or Replace, what is the data type of the filed in the target table?