SAP Knowledge Base Article - Preview

2751123 - SSIS deployment error Exception has been thrown by the target of an invocation or Sourced failed valiadation - SDK for SAP ASE

Symptom

Data Fow Task: Error: ADO NET Source failed validation and returned error code 0xC0208449
There were error during task validation
Dat Flow Task Error: One or more component failed validation
'ADO NET Source has failed to acquire the connection with the following error message:
"Exception has been thrown by the target of an invocation."'

Sybase ODBC:Error: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server
Data Row Task:Error: The AcquireConnectionmethod call to the connection manager xxxxx failed with error code 0xC0014009. There may be error messages posted before this with more informaiton on why the AcquireConnection method call failed.
Data Flow Task:Error: ODBC Source failed validation and returned error code 0x80004005
Data Flow Task:Error: One or more component failed validation.
SSIS xxxxxx Sybase ODBC:Error: An ODBC error -1 has occurred.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7 SPxxx
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0 SPxxx PLxx
  • Adaptive Server Enterprise ODBC Driver by Sybase
  • Adaptive Server Enterprise ADO.NET Data Provider
    • 3.5 Provider ( Sybase.AdoNet35.AseClient.dll )
    • 4.0 Provider ( Sybase.AdoNet4.AseClient.dll )
    • 4.5 Provider ( Sybase.AdoNet45.AseClient.dll )
  • Microsoft MSSQL Server
  • SAP Adaptive Server Enterprise
  • SSIS
  • .net

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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