Performing lookups by joining sap data with reference dataset in SSIS

In an SAP table many fields can belong to the table key. In some scenarios when you extract an SAP table with Xtract IS to load it into an SQL table, you want to replace the SAP key fields by another custom key, e.g. a GUID. The customer sales data (KNVV) table e.g. has the following fields as key: MANDT: Client KUNNR: Customer Number VKORG: Sales Organisation VTWEG: Distribution Channel SPART: Division 247continue reading →