dynamic schema import wrong data type

[Anonymous]

Hi every one,

i have a simple Job like this:

tinputdelimitedFiles ==> tmssqloutput.

the columns in the tinputdelimitedFiles are: ID(int),Name(varchar),others(dynamic, which contain 2 columns: Sale(int) and Discount(int))

i import the csv. File in to a Sale Table in MSSQL and when i open the Sale Table. the columns Sale and Discount have Data type as varchar.

i have try to change the Setting of Database Datatype of the dynamic Column "others" in the tmssqloutput to integer, and run the job again, but it still show me the same Data type for Sale and Discount.

Can you please help me how to import correct Data type of the column Sale(int) and Discount(int) when we use dynamic schema?

Thankyou

[akumar2301]

did you try tSetDynamicSchema and try to send column data type as id_Ineger.

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/_N82Hv0ivAnxD69EWaC5rA?section=jzhang-20120422...