SSIS Components for Smartsheet

Build 24.0.9062

CopyRowsToAnotherSheet

Copy rows form to another sheet.

Input

Name Type Required Description
SheetId String False Id of the sheet to be copied from.
RowIds String False Array of rows to copy. Comma separated values. Required if RowIdsFilePath is not specified.
RowIdsFilePath String False The full path to the local text file which stores the comma separated list of Row Id-s to be copied. Required if RowIds is not specified.
DestinationSheetId String False Id of the destination sheet.
Include String False Optional. A comma-separated list of row elements to copy in addition to the cell data: attachments, discussions, children or all to include everything (attachments, discussions, children or all).
IgnoreRowsNotFound String False Optional. true or false: default is false. If set to true, specifying row Ids that do not exist within the source sheet does not cause an error response. If omitted or set to false, specifying row Ids that do not exist within the source sheet causes an error response (and no rows are copied).

Result Set Columns

Name Type Description
Success String Whether or not the rows was copied successfully.
AffectedRows String The number of copied rows.

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