SSIS connection to Mailchimp API


In this article, we’ll demonstrate how to connect to Mailchimp using ZappySys tools and retrieve data. Our Zappysys SSIS Mailchimp Connector is a powerful way to integrate your marketing data seamlessly.


  • SSIS PowerPack: Please download the product here


You must create the token here with your logged account. More information in the Mailchimp API documentation here

  1. Begin by setting up a Data Flow in your SSIS package.

  2. drag and drop the API Source component inside the Data Flow.

  3. Create a new connection by clicking on Select Connection within the API Source.

  4. From the Choose from popular connector list, opt for the MailChimp connector, and proceed.

  5. Choose API KEY as the authentication type, and provide the required information. Note: Identify the DC (Data Center) in the initial part of your MailChimp URL, e.g., implies us1 is the DC.

  6. Test the connection to ensure its validity and save the configuration.

  7. Select the desired table/endpoint from the list within the API Source.

  8. Utilize the preview button to examine the retrieved information.


Connecting to Mailchimp using ZappySys tools streamlines data integration and retrieval. If you encounter any issues or need further assistance, feel free to contact our support team via chat on our website


You can find detailed information about our SSIS Mailchimp Connector in this article.