In CRM/CDS Destination Component of SSIS Integration toolkit we can found 2 output column as part of error handling
In case of Create
- CrmRecordId will have the GUID of the newly created record, which could be used for any further processing
- IsNew will list whether this is a new record or not.
Our package: –
Suppose we have the following record in our source (here ID is the alternate key column used for Upsert)
If all the records are new and are created we will get the following output.
Now if we delete the Test User 2 and Test User 3 record and run the package again, which should now create 2 records and update one record i.e. Test User 1 during Upsert.
The output would be as below
It will return the GUID of the record irrespective of Update or Create and IsNew will specify whether the record is newly created or updated.
Hope it helps..