Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
2 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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