How to get column name and column value when using dynamic command MSSqlInput

ngoctuan04th2 — Fri, 02 Jan 2026 14:45:42 GMT

Dear all,

I have a MSsqlinput , inside have 1 query command "select * from sec" (it can dynamic not fixed ) so i not create schema for it.

How to get column name and column value by Tjava or not ?

Thank you very much.

Re: How to get column name and column value when using dynamic command MSSqlInput

Anonymous — Mon, 09 Oct 2023 13:20:41 GMT

In this case you want to add a column that has type Dynamic.

Columns will be mapped to that single object.

You could also read about it here: https://help.talend.com/r/en-US/8.0/dynamic-schema/tsetdynamicschema-tfileinputpositional-tfileoutputpositional-tfixedflowinput-configuring-second-subjob-reading-and-writing-positional-data-standard-component-enterprise

And this JIRA has some java code: https://jira.talendforge.org/browse/TDI-48091

topic How to get column name and column value when using dynamic command MSSqlInput in Talend Studio

How to get column name and column value when using dynamic command MSSqlInput

Re: How to get column name and column value when using dynamic command MSSqlInput