SSIS - how to export a table without column name into excel

Question

i want to export a whole table without column name into excel, however, i add a "OLE DB Source" as a source and create SQL server connection and select the table name. ( there are 2 columns when i preview)

after that, i create a "Excel destination" and create a excel connection with setting up the outputpath from variable. and then select "Table or view" in Data access mode, when i preview the data, there is only 1 column

how to setup the output object (Excel destination), so that there are 2 columns (same as source from "OLE DB source")?

template is blank and only rename the worksheet as summary

there are 2 column in OLD source

in excel destination, there is only 1 column, how to make it same as source to display 2 columns without column name.

Answer 1

how to remove the first row after i export the excel.