The Modify RowSet task allows you to add, modify, or delete columns from a RowSet that was generated by tasks that read the contents of a file or database (for example, SQL or Read CSV tasks). The results of the Modify RowSet task are saved to an Output RowSet variable.

You have the option of modifying the existing columns and their index order, or you can define new columns with an index order of your choosing. Modifying existing columns is useful when the RowSet data needs slight modifications to meet the desired requirements. Identifying all new columns is preferred when the Input RowSet requires several changes to RowSet data and/or drastic changes to the column Index order.