SSIS Components for Azure DevOps

Build 24.0.9060

WorkItemBoardSnapshot

List WorkItemBoardSnapshot

Columns

Name Type References Description
ParentReference String
BoardLocationSK [KEY] Integer
DateSK Integer
WorkItemId Integer
ActivatedByUserSK String
ActivatedDate Datetime
ActivatedDateSK Integer
Activity String
AreaSK String
AssignedToUserSK String
AutomatedTestId String
AutomatedTestName String
AutomatedTestStorage String
AutomatedTestType String
AutomationStatus String
BacklogType String
BoardCategoryReferenceName String
BoardId String
BoardLevel Integer
BoardName String
BusinessValue Integer
ChangedByUserSK String
ChangedDate Datetime
ChangedDateSK Integer
ClosedByUserSK String
ClosedDate Datetime
ClosedDateSK Integer
ColumnId String
ColumnItemLimit Integer
ColumnName String
ColumnOrder Integer
CommentCount Integer
CompletedDate Datetime
CompletedDateSK Integer
CompletedWork Double
Count Double
CreatedByUserSK String
CreatedDate Datetime
CreatedDateSK Integer
CycleTimeDays Datetime
Done String
DueDate Datetime
Effort Double
FinishDate Datetime
InProgressDateSK Integer
IntegrationBuild String
IsBoardVisible Boolean
IsColumnSplit Boolean
IsCurrent Boolean
IsDefaultLane Boolean
IsDone Boolean
IsLastDayOfPeriod String
Issue String
IterationSK String
LaneId String
LaneName String
LaneOrder Integer
LeadTimeDays Double
Microsoft_VSTS_CodeReview_AcceptedBySK String
Microsoft_VSTS_CodeReview_AcceptedDate Datetime
Microsoft_VSTS_CodeReview_ClosedStatus String
Microsoft_VSTS_CodeReview_ClosedStatusCode Double
Microsoft_VSTS_CodeReview_ClosingComment String
Microsoft_VSTS_CodeReview_Context String
Microsoft_VSTS_CodeReview_ContextCode Double
Microsoft_VSTS_CodeReview_ContextOwner String
Microsoft_VSTS_CodeReview_ContextType String
Microsoft_VSTS_Common_ReviewedBySK String
Microsoft_VSTS_Common_StateCode Double
Microsoft_VSTS_Feedback_ApplicationType String
Microsoft_VSTS_TCM_TestSuiteType String
Microsoft_VSTS_TCM_TestSuiteTypeId Double
OriginalEstimate Double
ParentWorkItemId Integer
Priority Integer
ProjectSK String
Rating String
Reason String
RemainingWork Double
ResolvedByUserSK String
ResolvedDate Datetime
ResolvedDateSK Integer
ResolvedReason String
Revision Integer
Risk String
Severity String
StackRank Double
StartDate Datetime
State String
StateCategory String
StateChangeDate Datetime
StateChangeDateSK Integer
StoryPoints Double
TagNames String
TargetDate Datetime
TeamSK String
TimeCriticality Double
Title String
ValueArea String
Watermark Integer
WorkItemRevisionSK Integer
WorkItemType String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060