Sorry for the lack of detail earlier,
Here is the traceback report,
Traceback (most recent call last):
File "Path\ExtractDataToCSV.py", line 37, in <module>
extract = in_connection.execute(sql)
File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\arcobjects\arcobjects.py", line 27, in execute
return convertArcObjectToPythonObject(self._arc_object.Execute(*gp_fixargs(args)))
AttributeError: ArcSDESQLExecute: SreamBindOutputColumn ArcSDE Error -65 \uda10
So this happens when I include the geometry column that has multiple geometry types. Without it, the table loads fine. I can load the geometry type but I have to do something like this,
"cast(GeoLocation as varchar(8000)) as GeoLocation"
This will load it as string but still I have to work a process to convert them as geometries. Wondering if there is a simpler or better way of reading sql tables like this.
Thanks Dan
