topic Issue exporting rows from a Query Layer in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/issue-exporting-rows-from-a-query-layer/m-p/792129#M2171 <HTML><HEAD></HEAD><BODY><P>I'm attempting to export a table view (query layer) from a SQL database (not a gdb) using the Copy Rows tool, and am getting the not so helpful "ERROR 999999: Error executing function.".&nbsp; &nbsp;So far I've tried this in a stand alone python script, and&nbsp;the model included below for reference.</P><P></P><P>When I try this in ArcMap it works fine, using File-&gt;Add Query Layer, then right-click and export on the resulting layer.&nbsp; Any ideas, has anyone else run into this?&nbsp; &nbsp;Thank you.</P><P></P><P><IMG __jive_id="496922" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/496922_pastedImage_2.png" /></P></BODY></HTML> Wed, 17 Jun 2020 15:47:26 GMT AdamCrateau 2020-06-17T15:47:26Z Issue exporting rows from a Query Layer https://community.esri.com/t5/geodatabase-questions/issue-exporting-rows-from-a-query-layer/m-p/792129#M2171 <HTML><HEAD></HEAD><BODY><P>I'm attempting to export a table view (query layer) from a SQL database (not a gdb) using the Copy Rows tool, and am getting the not so helpful "ERROR 999999: Error executing function.".&nbsp; &nbsp;So far I've tried this in a stand alone python script, and&nbsp;the model included below for reference.</P><P></P><P>When I try this in ArcMap it works fine, using File-&gt;Add Query Layer, then right-click and export on the resulting layer.&nbsp; Any ideas, has anyone else run into this?&nbsp; &nbsp;Thank you.</P><P></P><P><IMG __jive_id="496922" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/496922_pastedImage_2.png" /></P></BODY></HTML> Wed, 17 Jun 2020 15:47:26 GMT https://community.esri.com/t5/geodatabase-questions/issue-exporting-rows-from-a-query-layer/m-p/792129#M2171 AdamCrateau 2020-06-17T15:47:26Z