Dear Forum members,
I have a different requirement. I am executing few SP's and writing the result in excel destination.
The issue I face here is as the excel is like a dashboard. It has some data in it. So when the SSIS package executes. It writes the data below the existing data.
To simplify, I have around columns A to P in the excel dashboard with 112 rows. Out of which all the columns like A, B, C, D, G, H, I, J, K, L, N, O, P have some data. I need to just fill E, F and M columns. So when the SSIS package executes, it writes the data at the bottom of the page i.e after 112 nd row.
Is there anyway where I can directly populate the E, F and M columns along with the default data values in the excel sheet from Row 1 to 112. Explain in detail.
Thanks in advance.