Using SSIS to migrate data from SQL Server to MongoDB


This article will show an example of exporting data from an SQL server to MongoDB using our MongoDB destination.


  • SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from this site.
  • MongoDB database


  1. Add a Data Flow Task: Drag and drop a Data Flow task into your SSIS package.

  2. Add an OLE DB Source:

    • Inside the Data Flow, select an OLE DB connection and a source table.
    • Preview the data and press OK to save the configuration.
  3. Create a MongoDB Connection:

  4. Configure the New MongoDB Connection:

    • Set up the host, username, password, and database.
    • Check the other tabs for additional configuration options.
    • Test the connection to ensure it is working.
  5. Add a MongoDB Destination Component:

  6. Run the Package: Execute the package, and you will see the data in MongoDB.

Video Tutorial

Watch a detailed video tutorial on this process:
Video Tutorial


This tutorial ensures a seamless process for exporting data from your SQL server into your MongoDB using SSIS. If any issues arise, please get in touch with our support via chat on our website.