Given a database “dt” with the following header:
“Surname, Address, Zip Code, Given Name, Phone Number”.
What is the correct configuration of the Invoke Method activity so that the resulting header will be:
“Surname, Given Name, Address, Zip Code, Phone Number”.
To rearrange the columns so that the resulting header will be “Surname, Given Name, Address, Zip Code, Phone Number”, you need to use the SetOrdinal method to reposition the 'Given Name' column to the index 1, right after 'Surname'. The correct configuration should include dt.Columns("Given Name") as the TargetObject, SetOrdinal as the MethodName, and 1 as the Value for the parameter. Therefore, Option C is correct.
The Start of the command is 0
You can test in studio using a build data table to create the original database column(dt). Then the invoke method, for target object use: dt.Columns("Given Name") and the method SetOrdinal. Use output datatable and log message to view output. Set the arguments like in the question at the parameter property.
C is the correct one