Extracting data table with header from sql database




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!


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.


Yeah. That worked.

Thanks Clayton!