sql to excel transfer data in multiple sheets

• xaprios

  SSC Enthusiast

  Points: 107

  More actions

  October 22, 2009 at 1:24 am

  #138963

  Hi friends,

  Can anyone help me out how to extract data SQL and insert in into excel file : if records in more than 65,536 then it improt it to multiple excel sheets (same excel doc having multiple sheets) using SSIS 2005

  Thnx...

• kumar2iyer

  Newbie

  Points: 3

  More actions

  June 29, 2010 at 12:52 pm

  #1186642

  Hi,

  I just wanted to know if you got a solution to your problem.

  If yes, could you please let me know what you did to make this work?

  Thank you.