I have a spatial data set that contains line data that I need to write to a MSSQL table. Unfortunately at the moment the table is being created but no data is being written to it despite FME saying it is successful. I have my writer set up and it can be seen in the attached screenshot. I'm wondering how I can force the data into the table?
Anything in the log?
There are warnings but no errors and it says translation was successful. The number of features I expect to be written are written according to FME
There are warnings but no errors and it says translation was successful. The number of features I expect to be written are written according to FME
I believe the translation is always succesful unless it get terminated, so translation succesful might be a bit misleading.
How do you check the result? Can you try and use another workspace to read the written table? My MSSQL knowledge / experience is zero. This is what I would try to check if the resulting table has any feature.
I would also try to fix the warnings in the log. Got quite focussed on blue text in the years using FME.
There are warnings but no errors and it says translation was successful. The number of features I expect to be written are written according to FME
I've checked the resulting table in MSSQL studio and it is blank; the column headings are there but there is no data in the table.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.