[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2787
  • Last Modified:

The PrimeOutput method on component "OLE DB Source" (13) returned error code 0xC0202009.

Hi I am getting this error , local it is working fine when i move this package to testing then i am getting below error,
this is happening some time only not all the times
could you please help me this , this very urgent for me


Error: 2011-09-28 05:56:56.63
   Code: 0xC0202009
   Source: Problem OLE DB Source [13]
   Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
End Error
Error: 2011-09-28 05:56:56.65
   Code: 0xC0047038
   Source: Problem SSIS.Pipeline
   Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "OLE DB Source" (13) 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
0
parpaa
Asked:
parpaa
  • 4
  • 2
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure the PIPe is enabled in SQL Service.
Or
If will not get solution then post descriptive error message.
0
 
parpaaAuthor Commented:
i am running this package throw Tidal by using  batch file
i am getting the above error only, thast is the full error message
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
HI,
Looks like you have a stored procedure as source..

This post will help you...
http://sqlserverpedia.com/blog/sql-server-2005/31-days-of-ssis-%E2%80%93-no-more-procedures-2031/

Regards,
Jason
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
Alpesh PatelAssistant ConsultantCommented:
If you are running package through Tidal then first try to run in BIDS and see the error log on last tab. You can see the exact error.
0
 
parpaaAuthor Commented:
I am running the package in BIDS with out any fail

when i am trying run in the tidal it is failing
0
 
parpaaAuthor Commented:
the packge runs evry day, some days running fine, some time it is failing
0
 
parpaaAuthor Commented:
ok
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now