SSIS Components for SharePoint

Build 20.0.7656

Tasks

Create, update, query, and delete items in a SharePoint Tasks list.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID of the item. The format of the ID is: List|ItemID.

List String False

The name of the issue tracking list.

Title String False

The title of the item.

Priority String False

The priority of the task.

Status String False

The status of the task.

PercentComplete String False

The completed progress of the task, expressed as a percentage.

AssignedTo String False

The SharePoint user the task is assigned to.

TaskGroup String False

The SharePoint group the task is assigned to.

Body String False

The description of the item.

StartDate Date False

The start date of the task.

DueDate Date False

The due date of the task.

WorkflowName String False

The name of the workflow associated with the task.

Author String False

The user that created the item.

Editor String False

The last user that modified the item.

Modified Date False

The date modified.

Created Date False

The date created.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CAMLQuery String

The query to be used while listing the list items.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656