Append rows in SAP Data Services

[Former Member]

Hi All,

I have created job in SAP Data Services. But when I am executing that job, the data in destination table getting replaced. My condition is I want to append rows in SQL table means in next week if I execute that job then it will append rows. How can I do this?

[ahalya_inturi · Accepted solution]

Hi Anand,

If you are using temp table , go to options tab in temp table

Un-check the box "Drop and re-create table " .

By default this option checked for temp table , so that on each run table will get drop and re create and will get load with the fresh data.

If you are using permanent table , go to options tab in permanent table

Make sure that , you are not selecting the option " Delete data from table before loading"

By default this option is un-checked for permanent table , it mean , new load data will get append to the old data.

So please check these 2 options before you load fresh run

Regards

Ahalya Gopinath

[Former Member · Accepted solution]

Thanks to all, your answer is helpful to me. My issue is resolved.

[Former Member]

Hi,

Click on the target table. Got to tab "options"

Uncheck the box "delete data before loading" (and uncheck maybe as well "truncate table").

In the section "update control" put "yes" on "Auto correct load" and "allow merge".

Depending on your model, check or uncheck other options.

Regards

Greg