UNABLE TO OPEN EXCEL SHEET AFTER PACKAGE EXECUTION

• pjesrani

  Say Hey Kid

  Points: 695

  More actions

  March 14, 2008 at 8:49 am

  #128304

  HI,

  I have a ssis package which exports data from sql database to excel sheet however upon executing it executes succefully however i connot open the excel file it gives the following error

  'Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.'

  This has become very frequent. However this was not the case before. What am i doing wrong.

• Tim Mitchell

  SSCoach

  Points: 15685

  More actions

  March 14, 2008 at 7:15 pm

  #789943

  You say that it worked fine "before".... has something changed in your environment or in the package?

  Is it possible that you're sending more rows than Excel is capable of handling (around 65,000)?

  I haven't done a lot of work with Excel as a destination in SSIS but I have used it as a source and my experiences have been, um, interesting.

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices