I was getting as 0x80040E21 error on a SSIS 2005 package when exporting some rows to an Excel file.

 

In my case this was caused by an input column of the type varchar(max) after converting this column in my t-sql query to a varchar(1024) column the error was resolved.

 

Error

Error: 0xC0202009 at Data Flow Task, Excel Destination [16]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
Error: 0xC0202025 at Data Flow Task, Excel Destination [16]: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Excel Destination" (16) failed the pre-execute phase and returned error code 0xC0202025.

One Comment

  1. hi i having a sql server database with having one column data type string 4000 length how to convert that length using data conversion transformaton, i am trying to convert on that but i gettng this error in the ssis package
    [Excel Destination [36]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
    [Excel Destination [36]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

    [SSIS.Pipeline] Error: component “Excel Destination” (36) failed the pre-execute phase and returned error code 0xC0202025.
    please help me n that

    mallu

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.