Connect SSIS to Office 365

Amir Zolfaghari 0 Reputation points

I need to connect my SSIS project to Office 365 for Outlook mailbox data.

What type of connection should I use and where can I find the configuration details?

Here is a screenshot of my SSIS connection manager.


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,950 questions
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
223 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
377 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 20,101 Reputation points

    Hi @Amir Zolfaghari ,

    We could not directly connect to Outlook mailbox data with the connector provided by SSIS.

    Script task is recommended to do that, you may refer to this.

    Or you may carefully use three-third party to meet your need.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.