exporting data to excel with dynamic column names

• bhatiamadhur

  SSC Enthusiast

  Points: 129

  More actions

  September 28, 2011 at 9:14 am

  #248483

  Hello,

  In SSIS I need to export the data to excel. While doing that is it possible to export the columns names too in the excel because the columns names in my table to exported are dynamic.

  As per my understanding I need to fix the template, but here is it possible to export the columns name too??

  I am stuck, pls help !!

  Regards,

  Madhur

• Phil Parkin

  SSC Guru

  Points: 247155

  More actions

  September 28, 2011 at 9:29 am

  #1387851

  Are you saying that the columns themselves are the same, but just that the column names are different?

  Or that you want to dynamically select which columns are exported and that their number and type may vary?

  ---

• bhatiamadhur

  SSC Enthusiast

  Points: 129

  More actions

  September 28, 2011 at 9:35 am

  #1387862

  There will be 15 columns total.. out of this 5 columns will have columns names as 2011_Q1, 2011_Q2.. like wise...Thus there will be 5 columns which will be dynamic

  Please let me know if further clarification is required.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  September 28, 2011 at 7:22 pm

  #1388154

  bhatiamadhur (9/28/2011)

  ---

  There will be 15 columns total.. out of this 5 columns will have columns names as 2011_Q1, 2011_Q2.. like wise...Thus there will be 5 columns which will be dynamic

  Please let me know if further clarification is required.

  How do you setup your columns to be dynamic? The standard SSIS data flow is static at runtime.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/