ssis how to use the excel template to output excel file

Question

hi, I would like to output sql server table A to excel file using the template with header

how can I develop a ssis using template to output file? the template contains header, I just output the data starting from row 2.

Answer 1

Hi @nononame2021 ,

Using the template file as the excel destination connection manager.

See here which shows how to Export data from SQL Server into an Excel template with SSIS.

Noticed that you have raised a lot of issues in Q&A and you are keeping asking in Q&A, if the issue has been resolved, don’t forget to click "Accept Answer" on the reply so that we could archive the case. : )

https://learn.microsoft.com/en-us/answers/support/accepted-answers

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.