One Star

Retrieve Schema Disabled Next Button After Selecting Tables

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
2 REPLIES
Seventeen Stars

Re: Retrieve Schema Disabled Next Button After Selecting Tables

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.
One Star

Re: Retrieve Schema Disabled Next Button After Selecting Tables

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