java.sql.SQLException Error

[Anonymous]

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?

[fdenis]

it's defined somewhere as Identity column so it's not a string.
check your metadata

[Anonymous]

Talend forced me to select the option "Specify Identity field". How can i ignore this? OR What to do for a successful transmission

[fdenis]

in witch component : tXxxxx ?

[Anonymous]

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.

[fdenis]

are you inserting or updating data?
you canuse tMSSqlOutput for MSSQL DB!

[Anonymous]

There too, if i select Create table then this option "Specify Identity field" pops up

[fdenis]

can you try with tMSSqlOutput

[Anonymous]

I was saying about tMSSqlOutput only. "Specify Identity field" option is there if i select create table. 

[fdenis · Accepted solution]

uncheck "Trun on Identity insert"