Database: How to get sql query results without column names

Help
1

I have a scenario where i need to execute a sql query(using DB activities) and store the result in the Output data table. The output data table should not have the column names and only the data values.

Please help.

2

I don’t think you’ll be able to remove the column names per se. You could rename them to something generic like ColumnA, ColumnB etc:

myDataTable.Columns(0).ColumnName = “ColumnA”

Or you could output the datatable via a Write CSV Activity and uncheck the headers property:

image