Clipboard (source ETL/ELT)
The clipboard (see details there) must have been filled in previous tasks. For this example, we assume that the clipboard was filled with the ETL/ELT source fields "Firstname", "Lastname" and "Points". See also section Examples (ETL/ELT).
Settings
(1) SQL query on clipboard: The query "SELECT * FROM @CLIPBOARD_TABLE@" would return all rows of the clipboard, but it can also be restricted with a WHERE condition, e.g. with WHERE Lastname='Hammer' or via ETL/ELT variable with WHERE Lastname='@NAME@'.
(2) Format SQL: Self-explanatory.