SSIS Components for Microsoft Project Server

The SSIS Integration Toolkit includes a Project Server Connection Manager, Source, and Destination components to connect to Project Server Instances. These components can be used with any other SSIS components to build your integration or migration project.

Installation and Setup

Microsoft Project Server
  • Project Server Connection Manager
    • Project Server Connection Manager allows you to specify how you want to connect to Project Server.
  • Project Server Source Component
    • Project Server Source Component is an SSIS data flow pipeline component that can be used to read/retrieve data from your Project Server instance.
  • Project Server Destination Component
    • Project Server Destination Component is an SSIS data flow pipeline component that can be used to write data to your Salesforce Marketing Cloud instance. You may Create, Update, Upsert, Delete, and Publish Project Server records using the Project Server Destination Component.