March 14, 2008 at 8:49 am
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.
March 14, 2008 at 7:15 pm
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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply