Error opening "SELECT "Column1","Column2","Column3","Column4","Column1" FROM "Table_Name""

[Mohd-Siddiqui]

Hi there,

I am tying to write data using Alteryx workflow into one of the tables in Microsoft SQL Server Management Studio 17.

I have used output tool and the configuration used in the output tool is mentioned below:

1. File Format - ODBC Database (odbc:) 

2. Output Options - Update; Insert if New

I am getting this error after the running the workflow:

Error opening "SELECT "Column1","Column2","Column3","Column4","Column1" FROM "Table_Name"". No Columns Returned.

Note: I have checked the incoming column names (in Alteryx workflow which needs to be loaded into table) and the table's column names and they are matching.

[AngelosPachis]

Hi @Mohd-Siddiqui ,

I'm not quite sure about it but in your SQL statement, instead of just adding the Table Name maybe try to also add the schema. So your query should be 

SELECT "Column1","Column2","Column3","Column4","Column1" FROM Schema.Table_Name

[Mohd-Siddiqui]

Hi @AngelosPachis,

I tried using your solution i.e. SELECT "Column1","Column2","Column3","Column4","Column1" FROM Schema.Table_Name , but the error is still not resolved.

Is there any other solution for resolving this error?