web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Export Data : More tha...
Microsoft Dynamics CRM (Archived)

Export Data : More than 100K records

(0) ShareShare
ReportReport
Posted on by Dhanabal 232

Hi Communities,

We're using online 2016 version. We've account entity that has more than 100K records.

Can we export it using with custom code if so, Please help me how?

Also, Is there any alternative way to achieve this one without coding?

Regards

Dhan

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    BharatPremji Profile Picture
    BharatPremji 2,485 on at
    RE: Export Data : More than 100K records

    Hi,

    You could use the Kingsway connector for SSIS:

    www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-365

    Regards

    Bharat

  • Dhanabal Profile Picture
    Dhanabal 232 on at
    RE: Export Data : More than 100K records

    Thanks Bharat

    I believe we can export records from SSRS also..Please tell me what is the difference here to use SSIS and SSRS?

  • Verified answer
    BharatPremji Profile Picture
    BharatPremji 2,485 on at
    RE: Export Data : More than 100K records

    Hi,

    SSRS is more for reporting, but your right you could create a report and then export it to Excel.

    However SSIS, will allow you to export (and transform, if you need to) the data to a SQL database for example

    Bharat

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
UllrSki Profile Picture

UllrSki 2

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans