SSIS Integration Toolkit for Microsoft Project Server by KingswaySoft is an extension for Microsoft SQL Server Integration Services (SSIS) that provides integration capabilities for Microsoft Project Server and related Project Online environments. The toolkit includes specialized connection managers and data flow components designed to interact with Project Server through supported APIs. It enables extraction of project-related data and loading of updates back into the system, supporting structured ETL processes within SSIS packages. The solution integrates into the SSIS development environment (Visual Studio / SSDT) and supports deployment to on-premises SQL Server Integration Services as well as Azure-SSIS Integration Runtime. It supports authentication mechanisms required by Project Server and Project Online environments. The product is intended for organizations that require automated data synchronization, reporting data extraction, or system integration involving project management data managed in Microsoft Project Server.

Key Features

Project Server Connection Manager Provides authenticated connectivity to Project Server or Project Online.

• Support for on-premises Project Server
• Support for Project Online
• Configurable authentication settings

Project Server Source Component Extracts data from Project Server entities.

• Access to projects, tasks, resources, and assignments
• Support for custom fields
• Query and filtering capabilities

Project Server Destination Component Loads or updates data in Project Server.

• Create and update operations
• Support for batch processing
• Handling of entity relationships

Metadata-Driven Configuration Uses Project Server schema definitions.

• Automatic metadata retrieval
• Field mapping support
• Custom field handling

Error Handling and Logging Supports reliable ETL execution.

• Detailed error outputs
• Execution logging
• Configurable retry behavior

Deployment Compatibility Supports Microsoft SSIS environments.

• SQL Server Integration Services (supported versions)
• Azure-SSIS Integration Runtime
• 32-bit and 64-bit runtime support

Benefits

Automated Project Data Integration Enables repeatable synchronization of project data.

• Scheduled ETL processes
• Reduced manual exports/imports
• Integration with enterprise systems

Improved Reporting Capabilities Facilitates extraction of structured project data.

• Centralized data warehouse loading
• Support for BI and analytics solutions
• Consistent data refresh cycles

Reduced Custom API Development Eliminates need for custom integration coding.

• Pre-built SSIS components
• Visual configuration
• Standardized integration patterns

Data Consistency and Control Supports validation and transformation before loading.

• Field-level mapping
• Error redirection
• Controlled update processes

Flexible Infrastructure Support Works across different deployment models.

• On-premises Project Server
• Cloud-based Project Online
• Azure-based SSIS runtime