Skip to main content
  • EN

Good afternoon,

I'm trying to write data to our companies Microsoft Azure SQL Database Non-Spatial database, but I keep getting an error saying

"Microsoft Azure SQL Database Non-Spatial Writer: Existing table for feature type `Roads' does not have attribute with name `id'. Cannot continue"

However, when I open up the Roads table inside the SQL database, I can see the field id. I've set the data type in the writer to match the SQL database type, and I still get the error.

David

What datatype is the "id" column? Are you sure it's "id" and not "ID"?

Rather than manually creating the FME writer definition, try importing the table from the Writers / Import feature types... menu.

Reply


Community Stats

30,108
Posts
114,290
Replies
37,743
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.