none
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21

    Question

  • Hi All,

    I am trying to execute SSIS package which has data flow task.In OLE DB Source I am using the MDX query and I want to redirect the output to .csv file.There are no errors even validation are shown in the task but when I am executing the package it is getting failed with following errors.

    [OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.

    [SSIS.Pipeline] Error: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.

    I am really not able to find the root cause of this errors. Can you please guide?

    I suscpect as MDX query return all data in WT_DSTR format and which is not getting mapped correctly in .csv file.

    Thanks,

    Vaibhav

    Thursday, July 07, 2011 9:24 AM

Answers

  • This issue did not occur once the target cube database got refreshed.May be unrefreshed cube was causing problem not sure though !

    Thanks,

    Vaibhav

    • Marked as answer by Abhiyanta Thursday, September 08, 2011 10:29 AM
    Thursday, September 08, 2011 10:29 AM

All replies

  • Do you have Configurations going on that might re-direct the Source to something that does not support that particular MDX statement?

    Have you tried copying the MDX and pasting it into an MDX query in SSMS? Does it return data as you expect?


    Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
    Thursday, July 07, 2011 11:59 AM
  • Hi Todd,

    Thanks for your reply.

    Yes. There are no issues with the MDX query.

    MDX query is giving me expected output in SSMS.

    Still not able to overcome this issue.Can you suggest any solution for the same.

    Thanks,

    Vaibhav

    Thursday, July 07, 2011 12:21 PM
  • This issue did not occur once the target cube database got refreshed.May be unrefreshed cube was causing problem not sure though !

    Thanks,

    Vaibhav

    • Marked as answer by Abhiyanta Thursday, September 08, 2011 10:29 AM
    Thursday, September 08, 2011 10:29 AM
  • Hi I have similar question but my target is SQL Source data to Excel Destination

    i am getting below error

     

    Error: 2011-11-29 07:35:52.60
       Code: 0xC0202009
       Source: Data Flow -Can onAssignment Excel Destination [130]
       Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred.
     Error code: 0x80040E21.
    End Error
    Error: 2011-11-29 07:35:52.60
       Code: 0xC0202025
       Source: Data Flow -Can onAssignment Excel Destination [130]
       Description: Cannot create an OLE DB accessor. Verify that the column metadat
    a is valid.
    End Error
    Error: 2011-11-29 07:35:52.60
       Code: 0xC004701A
       Source: Data Flow -Can onAssignment SSIS.Pipeline
       Description: component "Excel Destination" (130) failed the pre-execute phase
     and returned error code 0xC0202025.
    End Error
    Progress: 2011-11-29 07:35:52.61

    Tuesday, November 29, 2011 4:23 PM
  • Hi All,

    in my case, adding the "Format=Tabular" text to the connection string did the job.

    Martin

    Wednesday, September 04, 2013 9:34 AM