all groups > sql server dts > january 2006 >
You're in the

sql server dts

group:

Error on SSIS PrimeOutput()


Error on SSIS PrimeOutput() Jeff Lynch
1/19/2006 6:25:50 PM
sql server dts:
I'm using SSIS to pull data from a Unix based ERP system using an ODBC
driver and keep getting the following error.

[DTS.Pipeline] Error: The PrimeOutput method on component "Source - Query"
(1) returned error code 0xC02090F5. 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.

Where can I find what this error message and code mean?

--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch

Re: Error on SSIS PrimeOutput() Jeff Lynch
1/20/2006 8:03:05 AM
Peter,

We are using the ProvideX ODBC 3.31 driver and it works perfectly under SQL
2000 DTS but this error keep ocurring when we query large tables (many
columns, many rows) using the driver in SQL 2005 SSIS. I'll open a support
incident when I return from Redmond next week.

--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch


[quoted text, click to view]

RE: Error on SSIS PrimeOutput() petery NO[at]SPAM online.microsoft.com
1/20/2006 1:07:16 PM
Hello Jeff,

You could find the error message information from the following link:

http://msdn2.microsoft.com/en-us/library/ms345164.aspx

0xC02090F5 is code for DTS_E_DATAREADERSRCUNABLETOPROCESSDATA

The PrimeOutput method was unable to process the data.

Based on my research, this issue can be caused by the loss of logon
credentials after a max of 36 data fetch requests are sent by the SAP
Provider to the SAP Server in data shower mode. It seems this issue has
been reported to MS and we are tracking the issue but is still not fixed
yet. You may want to wait a while before you contact CSS to see if a fix is
available.

If you do not use SAP provider, it is more like a driver related issue.
Since it needs live debug/dump analysis to find the root cause, I recommend
that you open a Support incident with Microsoft Customer Support Services
(CSS) so that a dedicated Support Professional can work with you in a
timely and efficient manner.

For a complete list of Microsoft Customer Support Services phone numbers,
please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

315642 INF: Information that PSS needs to troubleshoot SQL Server
replication
http://support.microsoft.com/?id=315642

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469

Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
[quoted text, click to view]
Re: Error on SSIS PrimeOutput() vince.iacoboni NO[at]SPAM gmail.com
2/10/2006 1:43:01 PM
I'm seeing this same Prime Output 0xC02090F5 error when querying DB2
UDB through ODBC. I'm querying 5 medium-sized tables - sometimes they
work fine, sometimes just one table errors with this code, sometimes 3
of the 5 tables do.

Is there any news on a solution?

Vince Iacoboni
Deutsche Bank
AddThis Social Bookmark Button