Having ssis package to extract data from sql server to ms-excel 2003 format, when started debugging, validation gets completed but error in excel destination, getting error as
[Excel Destination [22]] Error: An OLE DB error has occurred. Error code: 0x80040E21. ,
[Excel Destination [22]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid. ,
[DTS.Pipeline] Error: component "Excel Destination" (22) failed the pre-execute phase and returned error code 0xC0202025.
and finally Task Data Flow Task failed
what to do??