DSXchange

Hi ,

i am using userdefined SQL for the UPDATE ACTION, the function of the
userdefined sql is it inserts the data into the table, i am adding more columns to the existing job, i mean it is a new column as per the business requirement, here i need to use update action as insert (or) update.

give me an information what is the best way to follow.

if i change the sql insert or update then it will work.

Please give me idea.

Thanks in advance.

Hi Vsi,

It depends on your specfications.If you want update the existing rows then you can use update or insert (as you have to insert new rows). Else use only insert option.

If you are editing the exisitng column, you need to edit the existing user defiled code as well.

"user defined", surely?