SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
A community member has associated this post with a similar question:
SSIS - how to export a table without column name into excel
Only moderators can edit this content.
SSIS - how to select table and export to excel without column name
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 71%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nononame2021
261
Reputation points
my database SQL server, i have a table name as "Summary" which contains 2 columns "Title" nvarchar(100) and "Info" nvarchar (100), i would like to select the whole table and export to excel without column name.
how can i do that in SSIS?
my table info.
my expected output excel result, it is same as database table but remove the column name and name the worksheet "Summary" and it can support re-run to replace the output excel, so it will not append the content to excel. how to do that?
SQL Server Integration Services
{count} votes