Extracting data table with header from sql database

datatable
studio
sql

#1

Hi,

I’m executing a stored procedure using execute query activity and storing the output table in a data table.

The extracted data table does not have header. I need header to further work with extracted table. What is the best way to extract table with header.

Thanks in advance!


#2

From my understanding, it does extract the table with the header. So my question is how are you checking if there is a header or not? If you use Write Range, make sure you have AddHeader checked.


#3

Yeah. That worked.

Thanks Clayton!