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

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/tec...rview/40010469

Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...rnational.aspx.

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

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


--------------------

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


"Peter Yang [MSFT]" <petery (AT) online (DOT) microsoft.com> wrote

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

Help!

I'm trying to create a simple .dtsx package that imports data to SQL server 2005 from an informix db using an ADO.net ODBC connection. I´m using the Informix ODBC Driver 2.90.TC3. The structure of my SSIS-package is quite simple:

(sqltask:truncate destination table) -> (sqltask:set isolation to dirty read at source) -> (sqltask: optimization: high at source) -> (data flow task)

My data source SQL-Query in the dataflow task is simple and it works great on a Informix test-db where no users are commited on the data. But when I test the thing on the working environment, the execution of the package fails, error output starts with the 0xC02090F5-error.

It seems that every SQL-task opens his own connection to the Informix-db. So I checked the box "retain same connection" at my source connection manager. However, the result is the same.

Has anyone an idea how to solve that problem?
Thanks in advance!