Connect SSIS to Office 365

Amir Hossein 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

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,296 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 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.
494 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,586 Reputation points
    2023-03-10T02:18:02.9066667+00:00

    Hi @Amir Hossein 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.

    0 comments