Skip to main content
Question

How to use the sqlexecutor to obtain the GEOM column from an MSSQL 2012 Database?

  • April 9, 2018
  • 1 reply
  • 8 views

Forum|alt.badge.img

The GEOM column in not read by the FME MSSQL Reader, and therefore it has been recommended to use the SQLExecutor to obtain the geometry. The transformer executes the SQL Statement for every row in the table, meaning that in my case with 1400 rows, the result is 1400*1400 in size.

What is the easyest way to just get the GEOM column from an mssql databse?

1 reply

david_r
Evangelist
  • April 9, 2018

You can probably replace the SQLExecutor with a SQLCreator, that way you only end up with 1400 rows.


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