SAP Knowledge Base Article - Preview

2643752 - OLEDB error Unsupported parameter type with SSIS Data Flow Task - SDK for SAP ASE

Symptom

  • 0xC0202009 at Data Flow Task, OLE DB Source [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
    An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x00000000  Description: "[HY000]
    [Native Code: 30071]
    [ASEOLEDB]Unsupported parameter type".
    Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: OLE DB Source failed the pre-execute phase and returned error code 0xC0202009.
    Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
    Task failed: Data Flow Task
     
  • In the ribo trace:
    DYNAMIC2 Token (0x62); variable length
      Length [4]:                   67
      Type [1]:                     DYN_PREPARE (0x01)
      Status [1]:                   DYNAMIC_SUPPRESS_FMT (0x02)
      Name Length [1]:              2
      Name [2]:                     "A0"
      Statement Length [4]:         58
      Statement [58]:               "CREATE PROC [A0] AS select * from authors where au_lname=?"
     
  • Happens with all datatypes, char, varchar, numeric and decimal.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • Adaptive Server Enterprise OLE DB Provider by Sybase
  • Microsoft MSSQL
  • SAP Adaptive Server Enterprise (ASE)
  • SSIS

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

CR#815602, CR815602, 815602, sybdrvoledb.dll, sybdrvoledb , KBA , BC-SYB-SDK , SDK , Bug Filed

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.