Error with output tool

Question

Hello, I'm new to the Alteryx Server and I finally got a workflow to upload without any errors to the Server.  However, when I run the flow on the server, I'm getting an error with my output tool.  Its configured to connect to a SQL database table and append the new records to the existing table.  When I run the flow, I'm getting the "Error opening....No Columns Returned" error.  This seems odd to me because It's not returning any columns from this table, it should be appending columns.  Has anyone had this issue before or know what I can do to fix this issue?

thanks so much

etechman · Accepted Answer

I was reading another thread (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Primary-Key-Required-for-Update-Option-but-Primary-Key-Exists/td-p/194412) where I found a workaround to use a Pre SQL Statement in my output tool.  The statement should be Use [Table Name].  I tried this and my flow was successful in running on the Alteryx Server.