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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.