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.
Tag as "solved" for others! Kudos to thanks!
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.