parpaa
asked on
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
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
ASKER
i am running this package throw Tidal by using batch file
i am getting the above error only, thast is the full error message
i am getting the above error only, thast is the full error message
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
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
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.
ASKER
I am running the package in BIDS with out any fail
when i am trying run in the tidal it is failing
when i am trying run in the tidal it is failing
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok
Or
If will not get solution then post descriptive error message.