tMSSQLInput and tMap - fields not showing

[talendstar]

I am trying to use tMSSQLInput along with tMap - however I don't see any columns in tMap and I also don't any columns in the Advanced Settings tab for the tMSSQLInput.

I am using a query within tMSSQLInput.

Any thoughts what I could be doing wrong here?

Thanks

[vapukov]

hi

click "Edit schema" and add 2 column (same as in your query) with proper datatype

or try to click Guess schema

before use schema - you must define it

[talendstar]

Thanks - that worked. Source columns are now showing in tMap. However I have now connected an output to tMap - but the destination columns are not showing in tMap Editor. How can I get destination columns in tMap? I don't see a "Guess Schema" for tMap output.

[vapukov]

oh!

ok, I will open You our big secret!

manually:

or copy - paste from source

or some other, more secret ways 🙂

nothing personal - but forum not a place for study so elementary moments, read the docs, watch the video on Youtube, and ask for interesting problems or when You are stuck