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.