Using SSIS to read data from any table returned by an RFC/BAPI with SAP ADO

EDIT: In the Adapter Pack V2, this option is supported out-of-the-box (the EXEC syntax in the SAP ADO Provider supports specifying which resultset should be returned as the first one). Please refer to the documentation on the supported syntax for this. SSIS source data flow components, by default return only the first result set returned…

5

Using WCF Adapters with SQL Server Integration Services(SSIS)

There are two ways the adapters belonging to Adapter Pack can be used by SQL Service Integration Services: 1. Using ADO layer built on top of base adapters. This option is available with SAP and Siebel adapters. 2. Writing custom SSIS task which directly invokes adapter to communicate with LOB system. Option 1 covers all…


Why does the Adapter say ‘Action is not understood’ even though I am using the binding file generated by the ‘Consume Adapter Service’ wizard?

Believe me, the adapter is telling the truth! It really doesn’t understand the action it got! To understand what’s going on, read on… When you use the ‘Consume Adapter Service’ wizard to generate LOB schemas in a BizTalk project, you also get a binding file which you can import (using the BizTalk Administration Console) to…

6

"Receiving IDocs from SAP using the SAPBinding requires higher SAP user privilege as compared to the older mySAP Adapter". Really??

Firstly, let me explain the common customer scenario using the old (mySAP 2.0) Adapter (NOTE – points in red and green below highlight the similarities/differences in configuration): The user, at design time, uses a high privilege account (let’s call it account A), to obtain the schemas for an IDoc. These schemas are deployed in a…

0