Query based vs. Query Publisher based integration

What is the current best practice when doing integrations into Dynamics 365 (on prem)?


Source data resides in SQL Server, but should I design using a Query based dts applying Bulk features?

Or, should I use a Query based publisher using the MSMQ?


Data arrives typically once each day and holds data for 2.000-50.000 account updates. Peak load is 500.000 accounts...


All articles and blog posts are 5+ years old on this subject and I suspect that Scribe has been enhanced since then.


I'd love to hear your thoughts on this.

(7) Answers