Dataverse: SSIS vs. ExecuteMultipleRequest


The article compares the performance of ExecuteMultipleRequest and SSIS for processing large data in Dynamics CRM. The author retrieves 88,606 contact records and creates a demo record based on that data. For SSIS, the author uses KingswaySoft for the SSIS Integration toolkit. The author then compares the time taken for both methods to complete the task. SSIS took 00:14:37.640, while ExecuteMultipleRequest took 00:14:47. The author concludes that ExecuteMultipleRequest performs well compared to SSIS, but SSIS requires less effort to configure and prepare the code.


Article 21m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time