Hello,
I have a problem writing my results from a geoprocessing service to an SDE feature class (SQL Express).
I tried creating a geoprocessing service that writes data to a file geodatabase on the server where ArcGIS for Server is installed and that works fine.
I also tried my created tool (created with model builder) locally to write to the sde feature class and that works fine as well.
I read that I have to save my tool in a folder on the GIS server together with a connection file to the SQl Express database, but I always get the same problem. (like: \\servername\folder\folder\Connection to servername_sqlexpress.sde)
I don't get an actual error, but when I run the geoprocessing tool the results are only saved in the arcgisjobs folder in the directories folder as well as in the GPInMemoryWorkspace database. There are no changes made in the sde feature class.
Can somebody please help me with this?
Ps: I use ArcGIS for Server 10.1 Workgroup and ArcSDE for Microsoft SQL Server 2008 R2 Express