SAP Knowledge Base Article - Preview

2777600 - Error 226 occurs when using a multi-statement transactions in SAP Data Services 4.2 x


When using ASE as the source Database and a multi-statement script with SELECT INTO from Data Services Desinger, the following error occurs.

@RUN-050304, ERROR, 0, 0.000, 1.406, 0.000, 0.000, 0:0, 0.000, 0, RUN-050304: |Session : Function call <sql ( <tablename>, select * into <tablename>.<database> from <tablename>.<Database> go ) > failed, due to error <70602>: <Sybase SQL Server <DD2> error message for operation <ct_results>: <Sybase Server message number <226> State <1> Severity <16> From Server <DD2>: Message Text is: SELECT INTO command not allowed within multi-statement transaction. >.>.



  • WINDOWS 2016
  • Information Platform Services 4.2 SP5 PL7
  • SAP Data Services 4.2 SP10
  • ASE 


SAP Adaptive Server Enterprise 16.0


Error 226, DBS - 70602, RUN-050304 , KBA , EIM-DS-EXE , Job Execution , 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.