topic Re: Retrieve Schema Disabled Next Button After Selecting Tables in Talend Studio

Retrieve Schema Disabled Next Button After Selecting Tables

Anonymous — Fri, 10 May 2013 22:20:11 GMT

I have an MSSQL connection that I want to add schema for but the NEXT button stays disabled.
Right-click, retrieve schema, leave defaults, click next, looks good, all tables exist, select all or any table, NEXT button stays disabled.
The "Columns" column is empty and the "Creation Status" column says pending.
Any ideas? Thanks in advance!
--steve

Re: Retrieve Schema Disabled Next Button After Selecting Tables

Anonymous — Fri, 10 May 2013 22:37:20 GMT

Yes I know. I have the same problem. Unfortunately there is currently no way so get over it.
I suggest, for input components like tMSSqlInput:
Define the query you want and use the Guess Schema button there. This usually works.
If you need an schema for an output component:
Do the same like for input but for your target table and copy the created schema and paste it to the output schema.

Re: Retrieve Schema Disabled Next Button After Selecting Tables

Anonymous — Fri, 10 May 2013 23:11:21 GMT

Thanks so much, I was pulling my hair out. I believe your solutions will work for me.
thanks again!
--steve