Subscribe to this APAR
By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.
| APAR (Authorized Program Analysis Report) |
Abstract
CA400EXP-OLEDB-INCORROUT Error 0x80040E00 in SQLServer SSIS
Error Description
In Visual Studio 2005, when creating an SSIS package for use
with MS SQL Server 2005, if a Data Flow task using IBMDASQL is
set to use SQL Command, the task fails with:
Error: An OLE DB error has occurred. Error code: 0x80040E00.
Error: The PrimeOutput method on component "OLE DB Source"(1)
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.
To recreate:
Create an Integration Services project (SSIS). For the Data
Flow task, create an OLE DB Source that uses the IBMDASQL
provider and an OLE DB Destination that uses the Native OLE
DB\SQL Native Client. For the OLE DB Source, select the
IBMDASQL connection and set the Data Access Mode to"SQL
Command" and type in the Select statement. If the Preview
button is clicked at this time the output of the select will be
displayed correctly.
Do a 'select * from qiws.qcustcdt' and then click on the Columns
(left pane) and it will show all the columns. Now link the green
output arrow to the OLE DB Destination. Edit the destination to
use the Object Linking and Embedding, Database (OLE DB)
connection to the local SQL Server DB and set Data Access Mode
to Table or View and then click the New button to automatically
create the target table in the local DB. Note that the statement
can be altered to give it a better table name. Click on the
Mappings (left pane) to verify the columns are mapping
correctly. Click on the Green arrow in the taskbar to Start
Debugging. This will run the task. The error described above
will occur.
No errors are logged in the CWBZZTRC trace or log file. An
iSeries TRCCNN shows nothing unusual or errors in the flows.
Problem Summary
The IBM DB2 for i5/OS IBMDASQL OLE DB Provider fails while
Using Visual Studio 2005 to create an SSIS package for use with
MS SQL Server 2005, if a Data Flow task using IBMDASQL is set
to use SQL Command, the task fails with:
Error: An OLE DB error has occurred. Error code: 0x80040E00.
Error: The PrimeOutput method on component "OLE DB Source"(1)
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.
Problem Conclusion
This PTF fixes the reported problem.
Temporary Fix
Comments
Circumvention
None.
PTFs Available
R530 SI30707 1000
R540 SI26879 7226
Affected Modules
Affected Publications
Summary Information
| Status............................................ | CLOSED PER |
| HIPER........................................... | No |
| Component.................................. | 5722XE100 |
| Failing Module.......................... | RCHMGR |
| Reported Release................... | R530 |
| Duplicate Of.............................. |
System i Support
-
IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.