Error: Output Data : Error opening "SELECT Columns" : No Columns Returned

[Jarnel]

I have a table named Buys in a database in SQL Server. I created a new table named _UAT_Buys by taking data from Buys table using input tool for 1 month and wrote it in UAT_Buys table using Output tool. It works fine.

I generated fresh data using workflow with same set of columns and trying to append this data to that UAT_Buys table using same output settings as above in Output tool and it gives be below error:

Error: Output Data (602): Error opening "SELECT Columns from Database.Tablename": No Columns Returned.

Can any one help on this. I tried using Pre SQL statement of "Use Databasename" but it does not help.

[Jarnel · Accepted solution]

This issue was due to an incorrect field name while writing data to the table. Issue was resolved after the field name was corrected.