Im inserting data into Excel using SSIS.
Im getting the following exception:
'[Excel Destination [32]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft Office Access Database Engine" Hresult: 0x80004005 Description: "Spreadsheet is full.".'
I did some research using the following link:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx
It states that you can populate the maximum of 1,048,576 rows by 16,384 columns
The data i am importing into Excel is only about 100,000 rows by 5 columns
Why am I getting this exception?
FYI the following is my Data Flow Task:
ODBC Source to Data Conversion transformation to Excel Destination
The best work around for this was to use a Flat File Destination and then import the Flat File directly from Excel. This proved to perform a lot better that using SSIS to import to Excel which is extremely slow. This work around imported my data almost instantaneously rather than having to wait a half an hour.