I have a field1 in my table1 in Remedy which I need to pull in a SQL table2 field2.
Both field 1 and field 2 are ntext fields.
When I try getting the field1 value in excel sheet, the fields1 gets pulled correctly.
When I try doing the same thing in SSIS and update the field2 the value does not get updated. field 2 is null.
The field1 has special characters like ", ) , and new line
How would I handle these. do the special characters cause this?
Is there any other way I could update field 2 .
Any help would be appreciated.