Error is this
Identity column 'MRNNo' must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, unencrypted, and constrained to be nonnullable.
Input field MRNNo is a string, how to handle this?
Solved! Go to Solution.
Don't forget to tag when it's "solved"!
Talend forced me to select the option "Specify Identity field". How can i ignore this? OR What to do for a successful transmission
I am exporting data from Excel to MSSQL DB
This option comes in tDBOutput.
MRNNo is alphanumeric, hence i cant select INT. MRNNo is string in both source and destination.