SAP Knowledge Base Article - Preview

1274781 - SQL server stored proc fails when called from Data Services / Data Integrator script element

Symptom

  • Call to execute a SQL Server stored procedure from within a Data Integrator / Data Services script element  is failing (i.e. sql('datastore','exec stored_proc'); )
  • Stored procedure works fine when  executed from SQL Server Query Analizer.


Read more...

Environment

  • Data Integrator Accellerated XI R2 (11.7.x)
  • Data Services 3,0, 3,1, 3,2 (12.0.x, 12.1.x, 12.2.x)

Product

SAP Data Integrator XI R2 ; SAP Data Services 4.0 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2

Keywords

BODI, BODS, DI, DS , KBA , EIM-DI , Data Integrator, Composer , EIM-DS , Data Services , 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.