Connect SSIS to Office 365

Amir Zolfaghari 0 Reputation points
2023-03-09T20:22:24.3133333+00:00

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.

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
Office
Office
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
    2023-03-10T02:18:02.9066667+00:00

    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.

    Regards´╝î

    Zoe Hui


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