SQL Server 2008 errors during export to Excel

[JustATheory]

Greetings,

The Export wizard was working fine until I realized that the Excel file limits were at the old 66k records instead of the 1million available in 2007. I needed to add Office 2007 compatibility components and now it errors and stops the export completely. The files are of the 2007 size, but data is not populating the worksheets.

Is there anything else I need to load, or adjustments I need to make?

Thanks,

JustATheory

 

[JustATheory]

Using the .txt export is fine, it's only occuring with an export to Excel.

Thanks,
Andy

 

[Qik3Coder]

What was the error you got while exporting?

[blue]The doc walks in.[/blue] The good news:[green]"It's just Grumpy Old Man Syndrome."[/green] The bad news:[red]"You're not even 30."[/red]

 

[JustATheory]

Here is the error message. I'd like to export to Excel, I have over 60 files that I need to export and one at a time as a text is to labor intensive.

Pre-execute (Error)
Messages
• Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
(SQL Server Import and Export Wizard)

• Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task 1: component "Destination – File_Detail_01" (46) failed the pre-execute phase and returned error code 0xC0202025.
(SQL Server Import and Export Wizard

 

[Qik3Coder]

And Excel 2003 works fine on that machine?

[blue]The doc walks in.[/blue] The good news:[green]"It's just Grumpy Old Man Syndrome."[/green] The bad news:[red]"You're not even 30."[/red]

 

[JustATheory]

Hi Qik3Coder,

Yes, I was exporting fine until I found the record limitation, added the components and now I'm erroring. I've been exporting individually to a text file, running a macro to enter them into one workbook, for import on a different machine. On a different machine, I can import and export to Excel no problem.

Thanks,
JustATheory