Show TOC

Function documentationTASKCOPYCOLUMNS Command Locate this document in the navigation structure

 

The TASKCOPYCOLUMNS command allows you to dynamically copy column settings of a given transformation. It is an executable command, similar to a TASK. It is only used in MODIFYSCRIPT.

The TASKCOPYCOLUMNS command uses the following syntax:

TASKCOPYCOLUMNS("TaskDescription","[source columns]","[destination columns]")

The following table details the parameters for the TASKCOPYCOLUMNS command.

Parameter

Description

TaskDescription

This parameter is the description property of the task that performs the column copy.

[source columns]

This parameter is the comma delimited range of columns of the source connection.

[destination columns]

This parameter is the comma delimited range of columns of the destination connection.

Note Note

The source columns find their corresponding columns in the destination columns on a positional basis. Ensure that the ranges of the source and destination columns have the same number of items. Double quotes (“) are required to mark the end of the source columns list and the beginning of the destination columns list. This command is only found in MODIFYSCRIPT. It does not appear when displaying the task properties of a package.

End of the note.