Question

Writing data to Microsoft Azure SQL Database Non-Spatial

  • 9 April 2018
  • 1 reply
  • 3 views
D
Badge

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

1 reply

david_r
Rank
Userlevel 4

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

28,707
Posts
109,479
Replies
36,553
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.