Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SSIS: DTS_E_OLEDBERROR and DTS_E_PRIMEOUTPUTFAILED Expand / Collapse
Author
Message
Posted Sunday, July 27, 2014 6:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:31 PM
Points: 501, Visits: 641
Hi Guys,

I have a Simple Package that Loads Data from Oracle Table to Sql Server Table.


For Source Connection i have used (Oracle Connection) : ORACLE PROVIDER FOR OLEDB
and Destination: SQL SERVER NATIVE CLIENT 10.0

It just a Plain Insert of Record without any Transformation. But While executing , After Inserting "323750"
records , package gets failed at OLEDB SOURCE.
Error is as Follows:
1) SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.



2) SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (200) 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.



I tried running package many times but after "323750" records it gets Failed. The Source (oracle) Table has around 20 Lakh reocrds.
Post #1596619
Posted Sunday, July 27, 2014 11:27 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:31 PM
Points: 501, Visits: 641
Anyone with updates on This ??
Post #1596690
Posted Monday, July 28, 2014 12:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
Anything special at row 323750?
Do you use a select statement at the source?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1596691
Posted Monday, July 28, 2014 1:20 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:31 PM
Points: 501, Visits: 641
Nothing Special with Source Data.

and Yes, i m using a Select Statement for Source.
Post #1596704
Posted Monday, July 28, 2014 1:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
If you only have the source component in the dataflow (and maybe just a multicast after the source), can you run the package without error?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1596707
Posted Monday, July 28, 2014 1:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:31 PM
Points: 501, Visits: 641
I ran the package with Source and Multicast . Package Executed but containers were not marked Red/Green. Got these Warning.


1. [OLE DB Source 1 [2261]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

2. [SSIS.Pipeline] Warning: Component "OLE DB Source 1" (2261) has been removed from the Data Flow task because its output is not used and its inputs either have no side effects or are not connected to outputs of other components. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something.

3. [SSIS.Pipeline] Warning: Component "Multicast" (2750) has been removed from the Data Flow task because its output is not used and its inputs either have no side effects or are not connected to outputs of other components. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something.

Post #1596709
Posted Monday, July 28, 2014 1:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
SSIS realized the data flow didn't do anything actually useful, so it removed the source and multicast at runtime (you did connect them together, right?). You can avoid this by setting RunInOptimizedMode to false on the data flow.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1596712
Posted Monday, July 28, 2014 1:51 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:31 PM
Points: 501, Visits: 641
Hi,


Can U please Explain This Point to me:

[OLE DB Source 1 [2261]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.


I See some problem with the CodePage Here.

It will be really Helpful if you can share something with codepage.
Post #1596715
Posted Monday, July 28, 2014 2:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
It took me 10 seconds of Googling to find the answer for the default code page warning (which is a warning, so it will not crash your package):

http://consultingblogs.emc.com/jamiethomson/archive/2005/10/25/SSIS_3A00_-Connect-to-Oracle.aspx




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1596716
Posted Monday, July 28, 2014 2:50 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:31 PM
Points: 501, Visits: 641
This is not helping.
Same Problem.
Post #1596730
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse