DSXchange

Hi,

Any one clarify me, which is the best method to import meta data i.e. Orchestrate method or Plug-in method. Because I am unable to import the table using Orchestrate schema definitions, but the same table imported using plug-in meta data schema definitions method. I am getting the following error while importing the table using Orchestrate method:
"Could not obtain a schema because prepare failed; the query was: SELECT * FROM Table name".

Thanks in Advance
Suresh

Orchestrate (via orchdbutil) is usually to be preferred, as it is more accurate.

Can you execute the same SELECT statement via any other client (not DataStage)?