none
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on OLE DB Source returned error code 0xC0202009

    Question

  • Hello,

    I'm running a MDX query in a SSIS package but the package fails with the following error:

    [OLE DB Source [96]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Analysis Services 2008."  Hresult: 0x80004005  Description: "Internal error: An unexpected exception occurred.".

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on OLE DB Source returned error code 0xC0202009.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.

    I'm using OLEDB Source and have set the Format=Tabular in the connection manager,but still the error persists. 

    Does anyone have a solution to resolve this issue or any suggestions that may help resolve the issue?

    Many Thanks!

    Thursday, January 09, 2014 11:33 PM

Answers

  • Hi nihcas7713,

    First, please click the “Test Connection” button in the In the OLE DB Connection Manager to check whether it connects to the SSAS cube successfully. If it failed to connect to the cube, check the Connection Manager’s credentials settings, cube’s security settings, Firewall settings, as well as the network connectivity.

    If it connects to the cube successfully, which “Data access mode” do you use for the OLE DB Source? If you use SQL command from variable, the issue might be caused by the length of MDX within the variable. You could check whether if it is the issue by using with another variable which contains a short and simple MDX query.

    In addition, if possible, you can try to update your SSIS as well as the SSAS instance.

    Hope this helps.

    Regards, 


    Mike Yin
    TechNet Community Support

    Tuesday, January 14, 2014 2:41 AM
    Moderator

All replies

  • That's pretty much a hard error meaning you have a serious mismatch somewhere.

    I suggest you share how others can reproduce your issue.

     

    Arthur My Blog

    Friday, January 10, 2014 3:04 PM
    Moderator
  • Hi nihcas7713,

    First, please click the “Test Connection” button in the In the OLE DB Connection Manager to check whether it connects to the SSAS cube successfully. If it failed to connect to the cube, check the Connection Manager’s credentials settings, cube’s security settings, Firewall settings, as well as the network connectivity.

    If it connects to the cube successfully, which “Data access mode” do you use for the OLE DB Source? If you use SQL command from variable, the issue might be caused by the length of MDX within the variable. You could check whether if it is the issue by using with another variable which contains a short and simple MDX query.

    In addition, if possible, you can try to update your SSIS as well as the SSAS instance.

    Hope this helps.

    Regards, 


    Mike Yin
    TechNet Community Support

    Tuesday, January 14, 2014 2:41 AM
    Moderator