SSIS Components for Microsoft Project

Build 21.0.7867

Tasks

Retrieve tasks.

Columns

Name Type References Description
ProjectId [KEY] String
TaskId [KEY] String
FlagStatus Bool
Health String
ParentTaskId String
ParentTaskName String
ProjectName String
TaskActualCost Decimal
TaskActualDuration Decimal
TaskActualFinishDate Datetime
TaskActualFixedCost Decimal
TaskActualOvertimeCost Decimal
TaskActualOvertimeWork Decimal
TaskActualRegularCost Decimal
TaskActualRegularWork Decimal
TaskActualStartDate Datetime
TaskActualWork Decimal
TaskACWP Decimal
TaskBCWP Decimal
TaskBCWS Decimal
TaskBudgetCost Decimal
TaskBudgetWork Decimal
TaskClientUniqueId Int
TaskCost Decimal
TaskCostVariance Decimal
TaskCPI Decimal
TaskCreatedDate Datetime
TaskCreatedRevisionCounter Int
TaskCV Decimal
TaskCVP Decimal
TaskDeadline Datetime
TaskDeliverableFinishDate Datetime
TaskDeliverableStartDate Datetime
TaskDuration Decimal
TaskDurationIsEstimated Bool
TaskDurationString String
TaskDurationVariance Decimal
TaskEAC Decimal
TaskEarlyFinish Datetime
TaskEarlyStart Datetime
TaskFinishDate Datetime
TaskFinishDateString String
TaskFinishVariance Decimal
TaskFixedCost Decimal
TaskFixedCostAssignmentId String
TaskFreeSlack Decimal
TaskHyperLinkAddress String
TaskHyperLinkFriendlyName String
TaskHyperLinkSubAddress String
TaskIgnoresResourceCalendar Bool
TaskIndex Int
TaskIsActive Bool
TaskIsCritical Bool
TaskIsEffortDriven Bool
TaskIsExternal Bool
TaskIsManuallyScheduled Bool
TaskIsMarked Bool
TaskIsMilestone Bool
TaskIsOverallocated Bool
TaskIsProjectSummary Bool
TaskIsRecurring Bool
TaskIsSummary Bool
TaskLateFinish Datetime
TaskLateStart Datetime
TaskLevelingDelay Decimal
TaskModifiedDate Datetime
TaskModifiedRevisionCounter Int
TaskName String
TaskOutlineLevel Int
TaskOutlineNumber String
TaskOvertimeCost Decimal
TaskOvertimeWork Decimal
TaskPercentCompleted Int
TaskPercentWorkCompleted Int
TaskPhysicalPercentCompleted Int
TaskPriority Int
TaskRegularCost Decimal
TaskRegularWork Decimal
TaskRemainingCost Decimal
TaskRemainingDuration Decimal
TaskRemainingOvertimeCost Decimal
TaskRemainingOvertimeWork Decimal
TaskRemainingRegularCost Decimal
TaskRemainingRegularWork Decimal
TaskRemainingWork Decimal
TaskResourcePlanWork Decimal
TaskSPI Decimal
TaskStartDate Datetime
TaskStartDateString String
TaskStartVariance Decimal
TaskStatusManagerUID String
TaskSV Decimal
TaskSVP Decimal
TaskTCPI Decimal
TaskTotalSlack Decimal
TaskVAC Decimal
TaskWBS String
TaskWork Decimal
TaskWorkVariance Decimal
LinkedAssignments String
LinkedAssignmentsBaselines String
LinkedAssignmentsBaselineTimephasedData String
LinkedBaselines String
LinkedBaselinesTimephasedDataSet String
LinkedIssues String
LinkedProject String
LinkedRisks String
LinkedTimephasedInfo String

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