SSIS Components for Microsoft Project

Build 21.0.7930

Tasks

Retrieve and modify tasks.

Table Specific Information

To query this table, the ProjectId must be specified either in the query's WHERE clause criteria or via the ProjectId connection property.

SELECT * FROM Tasks WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'

Columns

Name Type ReadOnly References Required Description
Id [KEY] String True false

ActualCostWorkPerformed Double True false

ActualDuration String True false

ActualDurationMilliseconds Int True false

ActualDurationTimeSpan Time True false

ActualOvertimeCost Double True false

ActualOvertimeWork String True false

ActualOvertimeWorkMilliseconds Int True false

ActualOvertimeWorkTimeSpan Time True false

BaselineCost Double True false

BaselineDuration String True false

BaselineDurationMilliseconds Int True false

BaselineDurationTimeSpan Time True false

BaselineFinish Datetime True false

BaselineStart Datetime True false

BaselineWork String True false

BaselineWorkMilliseconds Int True false

BaselineWorkTimeSpan Time True false

BudgetCost Double True false

BudgetedCostWorkPerformed Double True false

BudgetedCostWorkScheduled Double True false

Contact String True false

CostPerformanceIndex Double True false

CostVariance Double True false

CostVarianceAtCompletion Double True false

CostVariancePercentage Int True false

Created Datetime True false

CurrentCostVariance Double True false

DurationVariance String True false

DurationVarianceMilliseconds Int True false

DurationVarianceTimeSpan Time True false

EarliestFinish Datetime True false

EarliestStart Datetime True false

EstimateAtCompletion Double True false

ExternalProjectUid String True false

ExternalTaskUid String True false

FinishSlack String True false

FinishSlackMilliseconds Int True false

FinishSlackTimeSpan Time True false

FinishVariance String True false

FinishVarianceMilliseconds Int True false

FinishVarianceTimeSpan Time True false

FixedCostAccrual Int True false

FreeSlack String True false

FreeSlackMilliseconds Int True false

FreeSlackTimeSpan Time True false

IgnoreResourceCalendar Bool True false

IsCritical Bool True false

IsDurationEstimate Bool True false

IsExternalTask Bool True false

IsOverAllocated Bool True false

IsRecurring Bool True false

IsRecurringSummary Bool True false

IsRolledUp Bool True false

IsSubProject Bool True false

IsSubProjectReadOnly Bool True false

IsSubProjectScheduledFromFinish Bool True false

IsSummary Bool True false

LatestFinish Datetime True false

LatestStart Datetime True false

LevelingDelay String True false

LevelingDelayMilliseconds Int True false

LevelingDelayTimeSpan Time True false

Modified Datetime True false

Notes String True false

OutlinePosition String True false

OvertimeCost Double True false

OvertimeWork String True false

OvertimeWorkMilliseconds Int True false

OvertimeWorkTimeSpan Time True false

PercentWorkComplete Int True false

PreLevelingFinish Datetime True false

PreLevelingStart Datetime True false

RegularWork String True false

RegularWorkMilliseconds Int True false

RegularWorkTimeSpan Time True false

RemainingCost Double True false

RemainingOvertimeCost Double True false

RemainingOvertimeWork String True false

RemainingOvertimeWorkMilliseconds Int True false

RemainingOvertimeWorkTimeSpan Time True false

RemainingWork String True false

RemainingWorkMilliseconds Int True false

RemainingWorkTimeSpan Time True false

Resume Datetime True false

ScheduleCostVariance Double True false

ScheduledDuration String True false

ScheduledDurationMilliseconds Int True false

ScheduledDurationTimeSpan Time True false

ScheduledFinish Datetime True false

ScheduledStart Datetime True false

SchedulePerformanceIndex Double True false

ScheduleVariancePercentage Int True false

StartSlack String True false

StartSlackMilliseconds Int True false

StartSlackTimeSpan Time True false

StartVariance String True false

StartVarianceMilliseconds Int True false

StartVarianceTimeSpan Time True false

Stop Datetime True false

ToCompletePerformanceIndex Double True false

TotalSlack String True false

TotalSlackMilliseconds Int True false

TotalSlackTimeSpan Time True false

WorkBreakdownStructure String True false

WorkVariance String True false

WorkVarianceMilliseconds Int True false

WorkVarianceTimeSpan Time True false

LinkedCustomFields String False false

LinkedSubProject String False false

ActualCost Double False false

ActualFinish Datetime False false

ActualStart Datetime False false

ActualWork String False false

ActualWorkMilliseconds Int False false

ActualWorkTimeSpan Time False false

AddAfterId String False false

BudgetWork String False false

BudgetWorkMilliseconds Int False false

BudgetWorkTimeSpan Time False false

Completion Datetime False false

ConstraintStartEnd Datetime False false

ConstraintType Int False false

Cost Double False false

Deadline Datetime False false

Duration String False false

DurationMilliseconds Int False false

DurationTimeSpan Time False false

Finish Datetime False false

FinishText String False false

FixedCost Double False false

IsActive Bool False false

IsEffortDriven Bool False false

IsLockedByManager Bool False false

IsManual Bool False false

IsMarked Bool False false

IsMilestone Bool False false

LevelingAdjustsAssignments Bool False false

LevelingCanSplit Bool False false

Name String False false

OutlineLevel Int False false

ParentId String False false

PercentComplete Int False false

PercentPhysicalWorkComplete Int False false

Priority Int False false

RemainingDuration String False false

RemainingDurationMilliseconds Int False false

RemainingDurationTimeSpan Time False false

Start Datetime False false

StartText String False false

TaskType Int False false

UsePercentPhysicalWorkComplete Bool False false

Work String False false

WorkMilliseconds Int False false

WorkTimeSpan Time False false

LinkedAssignments String False false

LinkedCalendar String False false

LinkedParent String False false

LinkedPredecessors String False false

LinkedStatusManager String False false

LinkedSuccessors String False false

ProjectId [KEY] String True false

Id of the parent.

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