RCP Enabled Job deletes

manojbh31 · Post by **manojbh31** » Tue Apr 21, 2015 2:37 pm

Hi All,

I cannot write user defined query at target,

This is my requirement

I have RCP enabled job which creates a dataset with one column by joining 2 tables. Query is passed through parameters. Is it possible to delete the records by using dataset which is created using RCP from table? I need to delete data from 50 tables and each table has different key for deletion.

chulett · Post by **chulett** » Tue Apr 21, 2015 2:46 pm

Off you go to your own topic!

chulett · Post by **chulett** » Tue Apr 21, 2015 3:15 pm

This is about updates but thought it might help get you a starting point and/or methodology.