SSIS Components for Microsoft Project

Build 21.0.7867

Projects

Retrieve projects.

Columns

Name Type References Description
ProjectId [KEY] String
EnterpriseProjectTypeDescription String
EnterpriseProjectTypeId String
EnterpriseProjectTypeIsDefault Bool
EnterpriseProjectTypeName String
OptimizerCommitDate Datetime
OptimizerDecisionAliasLookupTableId String
OptimizerDecisionAliasLookupTableValueId String
OptimizerDecisionID Int
OptimizerDecisionName String
OptimizerSolutionName String
ParentProjectId String
PlannerCommitDate Datetime
PlannerDecisionAliasLookupTableId String
PlannerDecisionAliasLookupTableValueId String
PlannerDecisionID Int
PlannerDecisionName String
PlannerEndDate Datetime
PlannerSolutionName String
PlannerStartDate Datetime
ProjectActualCost Decimal
ProjectActualDuration Decimal
ProjectActualFinishDate Datetime
ProjectActualOvertimeCost Decimal
ProjectActualOvertimeWork Decimal
ProjectActualRegularCost Decimal
ProjectActualRegularWork Decimal
ProjectActualStartDate Datetime
ProjectActualWork Decimal
ProjectACWP Decimal
ProjectAuthorName String
ProjectBCWP Decimal
ProjectBCWS Decimal
ProjectBudgetCost Decimal
ProjectBudgetWork Decimal
ProjectCalculationsAreStale Bool
ProjectCalendarDuration Int
ProjectCategoryName String
ProjectCompanyName String
ProjectCost Decimal
ProjectCostVariance Decimal
ProjectCPI Decimal
ProjectCreatedDate Datetime
ProjectCurrency String
ProjectCV Decimal
ProjectCVP Decimal
ProjectDepartments String
ProjectDescription String
ProjectDuration Decimal
ProjectDurationVariance Decimal
ProjectEAC Decimal
ProjectEarlyFinish Datetime
ProjectEarlyStart Datetime
ProjectEarnedValueIsStale Bool
ProjectEnterpriseFeatures Bool
ProjectFinishDate Datetime
ProjectFinishVariance Decimal
ProjectFixedCost Decimal
ProjectIdentifier String
ProjectKeywords String
ProjectLastPublishedDate Datetime
ProjectLateFinish Datetime
ProjectLateStart Datetime
ProjectManagerName String
ProjectModifiedDate Datetime
ProjectName String
ProjectOvertimeCost Decimal
ProjectOvertimeWork Decimal
ProjectOwnerId String
ProjectOwnerName String
ProjectPercentCompleted Int
ProjectPercentWorkCompleted Int
ProjectRegularCost Decimal
ProjectRegularWork Decimal
ProjectRemainingCost Decimal
ProjectRemainingDuration Decimal
ProjectRemainingOvertimeCost Decimal
ProjectRemainingOvertimeWork Decimal
ProjectRemainingRegularCost Decimal
ProjectRemainingRegularWork Decimal
ProjectRemainingWork Decimal
ProjectResourcePlanWork Decimal
ProjectSPI Decimal
ProjectStartDate Datetime
ProjectStartVariance Decimal
ProjectStatusDate Datetime
ProjectSubject String
ProjectSV Decimal
ProjectSVP Decimal
ProjectTCPI Decimal
ProjectTimephased String
ProjectTitle String
ProjectType Int
ProjectVAC Decimal
ProjectWork Decimal
ProjectWorkspaceInternalUrl String
ProjectWorkVariance Decimal
ResourcePlanUtilizationDate Datetime
ResourcePlanUtilizationType Int
WorkflowError String
WorkflowErrorResponseCode Int
WorkflowInstanceId String
WorkflowOwnerId String
WorkflowOwnerName String
LinkedAssignmentBaselines String
LinkedAssignments String
LinkedDeliverables String
LinkedDependencies String
LinkedIssues String
LinkedRisks String
LinkedStagesInfo String
LinkedTasks String

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867