SE27941 - CA400EXP-OLEDB-INCORROUT Error 0x80040E00 in SQLServer SSIS

 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 PTF Cover Letter   1000
R540 SI26879 PTF Cover Letter   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:

(0 users)Average rating

Add comments

Document information


More support for:

i family

Software version:

V5R3M0, V5R4M0

Operating system(s):

OS/400

Reference #:

SE27941

Modified date:

2008-02-27

Translate my page

Machine Translation

Content navigation