Conditional table truncate

Hello

We have the situation where the AETL mapping should only truncate the target table if there are any rows coming from Datareader source at all. That is, lets say if 0 rows are coming out of Data Reader then it should not truncate target table.

I am using SQL before option

Serg

Which version have you got

www.dbsoftwarelaboratory.com/forum/rules.html

Peter

AETL Standard

Serg

Serg

For this you would need professional or enterprise version

Than you can write sql scrips to count number of records and if it is more than zero truncate it

See the picture attached

John