Microsoft Office Excel and SSIS

• devteam-875686

  Valued Member

  Points: 55

  More actions

  May 6, 2010 at 8:33 am

  #386865

  Hello,

  I am a beginner in SSIS.

  I'd like to export data to an Excel file within SSIS.

  Do I need to install Microsoft Office Excel on the server so that my export works?

  Thank you for your reply.

  Devteam.

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  May 6, 2010 at 8:43 am

  #1163279

  If you use the Excel destination in your dataflow you do not have to have Excel installed on the server.

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  May 6, 2010 at 8:10 pm

  #1163747

  I agree with Dan, SSIS supports Excel source and destinations out of the box without additional components.

  CEWII

• October 23, 2018 at 4:20 pm

  This was removed by the editor as SPAM