topic Re: tMSSQLInput and tMap - fields not showing in Talend Studio

tMSSQLInput and tMap - fields not showing

talendstar — Thu, 04 Oct 2018 20:04:27 GMT

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

Re: tMSSQLInput and tMap - fields not showing

vapukov — Fri, 05 Oct 2018 11:32:58 GMT

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

Re: tMSSQLInput and tMap - fields not showing

talendstar — Fri, 05 Oct 2018 15:22:30 GMT

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.

Re: tMSSQLInput and tMap - fields not showing

vapukov — Sat, 06 Oct 2018 04:55:57 GMT

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