I wanted to transfer data from DB to DB and in replacetext processor I have give SQL server merge statement, so that will send data like : if data in the DB need update or insert the merge statement will take care of that. I have 2 issues:
1) I want to automate that merge statement in replacetext processor, without manually writing SQL server merger statement (query). How can I do that.
2) I'm creating a dataflow, in one processor I'm sending the 5 different attributes but in the other processor, I want these 5 attribute should be come as single list and send it to the other processor.