SSIS Output to an Excel Template does not seem to follow formatting

Question

I have a fairly simple SSIS Package which extracts data daily from our SQL Server Database and outputs to an Excel Template that we have created and formatted accordingly to have centered data, numeric data, etc..

When we append the data to our Excel Template, how come it does not seem to follow the formatting correctly? The new data rows are not centered, the annoying green triangle appears to re-format the appended rows.

Is there any way that I can force the appended rows to follow the Excel Template formatting that we have set-up for it once the SSIS Package and the Data Flow Task is completed?

Answer 1

Hi @Bobby P ,

A workaround for you. Add a row with template data and formatting and hide that row.

Step1: Add a row containing numeric data in your excel file like shown below.

Step2: And then load data into the file you will not get the green triangle.

Step3: You may hide the first row or delete it after the loading.

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.