How do you set up an archive table job in Data Integration Studio? I need to insert new rows nightly and keep the old rows. I'm playing with the append transformation and merge transformation and having a hard time with both. It looks like the merge transformation is the way to go. For the merge transformation, I selected all columns from the source table on the insert tab. I selected only the composite key columns on the match tab. I know I'm missing a step.
The error message is One or more expression(s) are invalid. Please fix the expression(s). the insert statement is incomplete: Both the left and right operands are missing. Fix the invalid expression. The insert statement is incomplete: A set expression is missing a field or value.
