August 16, 2011 at 9:52 am
I have a SSIS package using SQL 2008 R2 . I have over 66000 rows in a table.
The excel is the destination which will be excel 2007 is the version i chose.
I already have MIcrosoft Office Access Database engine 2007 (english) on my local computer (Windows XP Professional). I donot have the Microsoft Office Professional Plus 2007 installed only Microsoft Office Professional Edition 2003 installed.
The package is simple design. Load the sql table into the Excel.
I get error of :
The input "Destination Input (84) failed because error code 0XC020907b occurred, and the error row dispostion on "input "Destination Input(84) specifies failure...
Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xc0047020.
When i looked at the excel report, it only loads up to 65536 rows and i looked at the version of excel it opened as: excel 2003.
I've verify that the SSIS package uses EXCEL 2007.
Anyone has faced this issue and solved it?
August 16, 2011 at 10:00 am
Anyone has faced this issue and solved it?
Save yourself from Excel hell and output to CSV instead. Then (apart from max row issues) it doesn't matter which version of Excel the users have, as long as they know enough to be able to open a CSV file in Excel (ie they can manipulate the File/Open dialog).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 16, 2011 at 10:12 am
The user requires Excel format.
Also, we have another box which is Windows 2008 R2 server 64 bit. It has Microsoft Office Professinal Plus 2007 installed, but no Microsoft Office Access database engine 2007 (english) installed.
SSIS package that uses SQL server 2008 R2 . A sql table with over 66000 rows is loading into the Excel (2007 is the version chose as the destination on the SSIS package). Again same exact error as when I did it locally on my Windows XP Professional box. It only seems to load up to 65536 rows.
Wonder is it because Microsoft Office Access database engine 2007 is missing?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply