Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Check Existing Leads or Create new in Bulk ?

(0) ShareShare
ReportReport
Posted on by 80

Hello Experts,

I want to check the existing lead records based on fullname and mobilenumber, if any record found with fullname and mobilenumber then fetch the lead-id in the list or  create a new lead and save its lead-id in the list, I am reading leads from an external data source and checking in the CRM within the console application. Here I have a very large population of lead to be processed so looking for the best approach to manage this requirement. 

Version - (CRM-2016-OnPrim)

Thanks

*This post is locked for comments

  • Suggested answer
    nitinagg16 Profile Picture
    nitinagg16 200 on at
    RE: Check Existing Leads or Create new in Bulk ?

    Hi,

    You can use SSIS or SCRIBE for given task.

    Thanks

    Nitin

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Check Existing Leads or Create new in Bulk ?

    This is the sort of operation that can be done quite easily in SSIS, using a lookup to the lead entity - as you have CRM OnPremise, you can use a SQL query for the lookup. SSIS is designed to perform well with very large data sets

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans