locked
SSIS Package Error SSIS Error Code DTS_E_PRIMEOUTPUTFAILED RRS feed

  • Question

  • Hi All ,

    I have a SSIS package which is running fine in BIDS
    Source: oracle
    Destination: SQL


    It is running fine on my local machine, but when I am running it on dev it is failing with following error

    Error: 2011-03-17 13:31:37.33 Code: 0xC0202009 SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2011-03-17 13:31:37.34 Code: 0xC0047038 Source: DFT - Get SAP Costing data from DW SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE_SRC" (1) 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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:29:34 PM Finished: 1:31:38 PM Elapsed: 123.163 seconds. The package execution failed. The step failed.

    Thanks in advance,

    Nipendra Garg

    Saturday, March 19, 2011 12:29 AM

All replies

  • Its more likely you might have different .net versions installed on your local and dev server. also worth to check both having same SQL server versions including service packs
    Sunday, March 20, 2011 3:48 PM
  • Give more specificaitons, like server Hardware, 64 Bit 32 Bit, OS etc etc, types of drivers you use to connect to Oracle

    Abhinav
    Sunday, March 20, 2011 6:28 PM
  • The package is running successfully in my local machine (Win XP SP3 32bit). The same package is not running in dev server (Win 2008 R2 Enterprise 64 bit). 

     

    Is this the problem because of Different OS (32 and 64 bit) ? If yes what are the steps to resolve the issue? I am using "Native OLEDB/ Oracle provider for OLEDB" driver to connect to the Oracle. When I am running my package on dev box it is giving me the following error.

    Error: 2011-03-17 13:31:37.33 Code: 0xC0202009 SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2011-03-17 13:31:37.34 Code: 0xC0047038 Source: DFT - Get SAP Costing data from DW SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE_SRC" (1) 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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:29:34 PM Finished: 1:31:38 PM Elapsed: 123.163 seconds. The package execution failed. The step failed.

    Any one have any idea about this error?

    Thanks in advance.

    Nipendra Garg


    Monday, March 21, 2011 5:05 PM
  • I tried to debug the package and following are the results : The query is running fine to fetch the data from Oracle when there are three tables in the join. Query fails when I add the fourth table in the join condition. Even the whole query is running fine in Sql developer/TOAD. I am getting following error : [OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) 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 Any help in this regard would be highly appreciated. Thanks, Nipendra Garg
    Monday, March 21, 2011 8:23 PM