Data Services General error;274 inserted value too large for column NAME1 field

[former_member5846]

Hi Expert,

Initially I have used regex_replace(input string ,'\[^a-z0-9\]','', 'CASE_INSENSITIVE') but my requirement is - have to keep special character as input & output value of the Name1 field.

Even I have used ltrim_blanks(rtrim_blanks(FieldName)) but issue has not been resolved.

Getting below error message :

Please share your advise.

Thanks in advance.

Cheers

Shamik

[Julian_Riegel · Accepted solution]

Hi there,

try to use NVARCHAR in the target table settings instead of VARCHAR.

https://answers.sap.com/questions/377913/data-services-general-error274-inserted-value-too-.html

regards,

Julian

[former_member5846 · Accepted solution]

Thanks a lot julian.riegel2 for your quick advice. Its working fine now.