SSIS MongoDB Destination: bulk insert, upsert, delete & reload into collections; load raw JSON from pipelines; nested array updates. Part of ZappySys SSIS PowerPack.
Load documents into MongoDB from SSIS with a native destination component.
Bulk insert, upsert, delete, and reload into collections; load raw JSON from upstream transforms or files; and update nested arrays (for example new order lines inside an existing customer document).
Part of ZappySys SSIS PowerPack.
Bulk write modes — Reload, insert, upsert, delete, and related bulk patterns for collections
Raw JSON documents — Map SSIS columns to full documents (for example from JSON Generator Transform)
Column mapping — Standard mapping tab for field-level loads alongside JSON scenarios
Array & nested paths — Support for operators such as $set and $push on embedded arrays
MongoDB connection manager — Reusable connection setup shared with other MongoDB components
Enterprise SSIS targets — SQL Server 2012 through 2025 and Azure-SSIS integration runtime
💡 Common Use Cases
SQL-to-NoSQL migration: Land normalized rows into MongoDB as documents for app modernization.
API landing zone: After REST/JSON extraction, bulk load response payloads into collections.
Upsert-driven sync: Keep MongoDB aligned with a system of record using key-based upserts.
Nested order or line items: Append or update items inside a parent document’s array from SSIS.
🎯 Summary
MongoDB Destination brings bulk insert, upsert, delete, and JSON-oriented loads into standard SSIS data flows—without custom code—so teams can treat MongoDB as a first-class ETL target alongside relational warehouses.
Trusted by Developers & IT Teams Worldwide
Built for SSIS Workflows: Purpose-built for high-performance ETL and complex integration scenarios.
Expert Technical Support: Direct access to engineers via email and remote screen-share sessions.
Proven Enterprise Scale: Trusted by 3000+ teams across 90+ countries, including Fortune 500.
