The PrimeOutput method on component "OLE DB Source

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

The PrimeOutput method on component "OLE DB Source

Author

Topic

boreddy
Posting Yak Master

172 Posts

Posted - 2011-09-29 : 07:22:42

Hi Expers

when i am running the package in visul studio this is running fibne
when i am trying run the pcakge in tidal i am getting the below error

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-29 10:29:13.04
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.
End Error

please help me this very urgent for me

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-09-29 : 08:16:45

What is "tidal"?

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-29 : 08:22:14

I dont think this has enough details on actual error? do you've any other messages returned with this?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

boreddy
Posting Yak Master

172 Posts

Posted - 2011-09-30 : 06:19:55

i am getting only above error message only

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-30 : 06:22:12

whats OLDEB source by the way? is it sql server itself?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

boreddy
Posting Yak Master

172 Posts

Posted - 2011-09-30 : 10:07:17

I am connecting the oracle data source

by using OLEDB connection
the provider we select is oracle provider for OLEDB

some times the package is running fine some time only throwing the error

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-30 : 11:02:59

then i feel like issue is with acquiring oracle connectivity. did you try creating linked server to that oracle and query using that? in that case, is the problem happening?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

boreddy
Posting Yak Master

172 Posts

Posted - 2011-10-07 : 04:51:51

when i am running this package in visul studio it is running fine,
when i am trying run the package by using dtexec in the ITG environment, i am getting above error and failing
but it is not happening all times, only few times it is happening

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-07 : 04:53:59

both cases are you using same account to execute package?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

boreddy
Posting Yak Master

172 Posts

Posted - 2011-10-07 : 05:21:36

yes, same account i am using

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources