web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Limitations to the dat...

Microsoft Dynamics AX (Archived)

Limitations to the data import into AX 2012

(0) Share

Report

Report

Posted on by Community Member

Hi,

We are planning to use SSIS or the a custom service endpoint to import data into several tables in AX 2012, every 2 hours.

I want to ask whether there are any limitations to the amount of data that can be imported at once, as we may rarely have cases where we would need to import 50 000 - 100 000 rows of data into AX 2012, and we want to know whether that is possible?

I read through some of the questions here and didn't find any limitations myself, but suggestions that the data should be split into chunks of up to 10 000 rows in order to manage the import better.

Thanks.

Best Regards,

Evgeni Dyulgerov

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 304,429 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi Evgeni,

There are no limitations in the number of rows. However like Crispin mentioned, hardware and sizing is important. You need to see if the custom service can handle it correctly. So do good full load tests. You can also have a lok at the data import export framework. This is using a two step strategy where initially data is loaded in staging tables. This process is very fast. Then the staging to target can be scaled using the batch framework and multiple threads to divide the workload.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 26

#2

#3

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans