Data Flow From SQL Server To Excel - 'Cannot Create An OLE DB Accessor'

Hello all,

I am creating an SSIS package that takes data from a SQL Server 2005 table, adds some columns, programatically changes some values based on business requirements, and then writes the output to an Excel template which I've already prepared. Everything seems to work fine, but the package always errors out when immediately after it hits the Excel Destintation component, with the following errors:

Error: 0xC0202009 at Process Quarterly Data, Export to Excel [12621]: An OLE DB error has occurred. Error code: 0x80040E21.
Error: 0xC0202025 at Process Quarterly Data, Export to Excel [12621]: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
Error: 0xC004701A at Process Quarterly Data, DTS.Pipeline: component "Export to Excel" (12621) failed the pre-execute phase and returned error code 0xC0202025.

I have verified that the Excel destination file is writing the correct headers to the specified file. I thought that the issue might be that one of the dynamically created columns isn't matching the Excel file, so I manually checked each and every one of them (there are 248 columns, although a lot of them aren't really used - however, we are required to use the template provided , so must include fields in the specified order whether or not they have any data) and made sure that I selected the exact same datatype for each column. However, I still get the error and no rows are written to the Excel file.

Here is the code generated by the Excel Destination Manager:





Generated Code - Excel Destination (SSIS)


CREATE TABLE `xxx_LoadData` (
`PART NUMBER` NVARCHAR(255),
`PART NAME` NVARCHAR(255),
`PRICE TBD` INTEGER,
`PRICE` MONEY,
`UOI` NVARCHAR(4),
`Items per UOI` INTEGER,
`NSN` NVARCHAR(255),
`OEM NAME` NVARCHAR(255),
`OEM PN` NVARCHAR(200),
`UPC` NVARCHAR(255),
`DESCRIPTION` NVARCHAR(255),
`EXPANDED DESCRIPTION` ntext,
`CLASSIFICATION CODE` NVARCHAR(255),
`DAYS ARO` INTEGER,
`IMAGE DESCRIPTION` NVARCHAR(255),
`IMAGE URL IF SELF HOSTED OR IMAGE NAME MANTECH HOSTED` NVARCHAR(255),
`SHIPPING WEIGHT` REAL,
`SHIPPING WEIGHT UNIT OF MEASURE` NVARCHAR(4),
`SHIPPING LENGTH` REAL,
`SHIPPING WIDTH` REAL,
`SHIPPING HEIGHT` REAL,
`SHIPPING UNIT OF MEASURE` NVARCHAR(4),
`PRODUCT WEIGHT` REAL,
`PRODUCT WEIGHT UNIT OF MEASURE` NVARCHAR(4),
`PRODUCT LENGTH` REAL,
`PRODUCT WIDTH` REAL,
`PRODUCT HEIGHT` REAL,
`PRODUCT UNIT OF MEASURE` NVARCHAR(4),
`FEDERAL SUPPLY CODE` NVARCHAR(255),
`ENAC CODE` NVARCHAR(255),
`PACKAGE UNIT OF ISSUE` NVARCHAR(4),
`PACKAGE UNITIP OF ISSUE` NVARCHAR(4),
`PACKAGE PRICE` MONEY,
`CERTIFIED NSN` NVARCHAR(255),
`COG CODE` NVARCHAR(255),
`HAZMAT` NVARCHAR(255),
`UNSPSC` NVARCHAR(255),
`SALE_START_DATE` DATETIME,
`SALE_END_DATE` DATETIME,
`PB1 Quantity` INTEGER,
`PB1 Zone 1 Price` MONEY,
`PB1 Zone 1 Sale Price` money,
`PB1 Zone 2 Price` money,
`PB1 Zone 2 Sale Price` money,
`PB1 Zone 3 Price` money,
`PB1 Zone 3 Sale Price` money,
`PB1 Zone 4 Price` money,
`PB1 Zone 4 Sale Price` money,
`PB1 Zone 5 Price` money,
`PB1 Zone 5 Sale Price` money,
`PB1 Zone 6 Price` money,
`PB1 Zone 6 Sale Price` money,
`PB1 Zone 7 Price` money,
`PB1 Zone 7 Sale Price` money,
`PB1 Zone 8 Price` money,
`PB1 Zone 8 Sale Price` money,
`PB1 Zone 9 Price` money,
`PB1 Zone 9 Sale Price` money,
`PB1 Zone 10 Price` money,
`PB1 Zone 10 Sale Price` money,

/* Repeated through PB10 Zone 10 - code not shown for brevity */


)
Does anyone have any suggestions as to what I'm doing wrong? I'm making an attempt to set up a process for the company, instead of throwing something together; while that would be much quicker (I've spent pretty much the whole day working on this), lack of processes are a big detriment to our current operations.

Any help would be greatly appreciated - I'm not that familiar with SSIS or its nuances just yet.