AnsweredAssumed Answered

arcpy.Append_management: ERROR 000187: Only supports Geodatabase tables and feature classes

Question asked by jsn on Oct 24, 2018
Latest reply on Nov 2, 2018 by JSimms-esristaff

Hello everyone,

 

I am getting the following error message when running in Python an append -arcpy.Append_management- between a table in SDE and a table from a SQL database.

 

This append  works fine in Model Builder.

 

# Process: Truncate Table

arcpy.TruncateTable_management(sde_Table)

 

# Process: Append

arcpy.Append_management("'Database Connections\\Consumption Production.sde\\Consumption.SQLDatabaseTable'", sde_Table__2_, "NO_TEST", "PREMID \"PREM_ID\" true true false 10 Text 0 0 ,First,#,Database Connections\\Consumption Production.sde\\Consumption.SQLDatabaseTable,PREMID,-1,-1;TOTALGALSEW \"TOTAL_GALLONS_WATER\" true true false 8 Double 2 18 ,First,#,Database Connections\\Consumption Production.sde\\Consumption.SQLDatabaseTable,TotalGallonsWater,-1,-1;GPD \"GALLON_PER_DAY\" true true false 8 Double 2 18 ,First,#,Database Connections\\Consumption Production.sde\\Consumption.SQLDatabaseTable,GPD,-1,-1", "")

Outcomes