Skip to main content
  • EN

I am reading some oracle tables (non spatial) and trying to write them out to to sql server tables using a dynamic schema. However, I constantly get this error:

 

Provider error `(2760) The specified schema name either does not exist or you do not have permission to use it.'

 

Please can someone let me know what I am doing wrong, otherwise I will have to add a separate reader and writer for each table

 

Many thanks

Mark

Sounds like the schema name isn't matching the feature names. Check that fme_feature_type has the exact same value on both the schema feature and the data features.

No reason it shouldn't - I used 'generate workspace' to build it so should all be automatic.

 

I do wonder if its because the names of the tables in Oracle have a dot (ie DatabaseName.TableName) - I don't think SQL like the dot

Reply


Community Stats

30,162
Posts
114,483
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.