SAP Knowledge Base Article - Preview

2425041 - SSIS with Ado.Net Source and Microsoft Ado.Net Provider for ODBC with the Sybase ODBC driver fails - SDK for SAP ASE

Symptom

  • Creating a SSIS package and using the Microsoft ADO.Net Provider for ODBC in combination with the Sybase Adaptive Server Enterprise Driver fails.
  • There are no column information returned, even though you can connect and see the table on the ASE.
  • There was an error displaying the preview. (Microsoft Visual Studio)
    [SSIS.Pipeline] Warning: The output column "pub_id" (169) on output "ADO NET Source Output" (21) and component "ADO NET Source" (16) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
    [ADO NET Source [16]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "ADO NET Source" (16)" failed because error code 0x80131937 occurred, and the error row disposition on "output column "pub_id" (169)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
    [ADO NET Source [16]] Error: The component "ADO NET Source" (16) was unable to process the data. Pipeline component has returned HRESULT error code 0xC0209029 from a method call.
    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ADO NET Source" (16) 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. There may be error messages posted before this with more information about the failure.
    Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
    Task Data Flow Task failed


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.0
  • Adaptive Server Enterprise ODBC Driver by Sybase
  • SSIS

Product

Sybase SDK all versions

Keywords

CR561317, 561317, CR#561317 , KBA , BC-SYB-SDK , SDK , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.