Skip to main content
Question

Writing data to Microsoft Azure SQL Database Non-Spatial

  • April 9, 2018
  • 1 reply
  • 8 views
D
Forum|alt.badge.img

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
Celebrity
  • david_rCelebrity
  • April 10, 2018

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


Helpful Members This Week

Community Stats

31,182
Posts
118,184
Replies
38,791
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.