SSIS source data flow components, by default return only the first result set returned by the underlying ADO. When working with BAPIs and RFCs that return multiple tables, the SSIS component would take the first table that it comes across. To demonstrate
Read More...
Attachment(s): SAPAdoSource.zip
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
Read More...
Attachment(s): SsisSiebel.zip