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 madhur_ms

Please check below links <p style="font-style: Thanks http://dwhanalytics.wordpress.com/

Please check below links http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/bda433aa-c8f8-47c9-9e56-efd20b8354ac/ and http://dwhanalytics.wordpress.com/2011/04/07/ssis-dynamically-generate-excel-tablesheet/ Thanks http://dwhanalytics.wordpress.com/

Please see if this example is exactly what you wan: http://www.rafael-salas.com/2006/12/import-header-line-tables-_116683388696570741.html It may be necessary to construct the right create table though.Arthur My Blog