Populating Result in Excel file - on a specific Column and Row.

• rockybhai

  SSCommitted

  Points: 1574

  More actions

  June 21, 2011 at 2:59 am

  #145823

  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.

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  June 21, 2011 at 8:14 am

  #1341857

  Direct replies here: http://www.sqlservercentral.com/Forums/Topic1128842-147-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato