Skip to Content
Oct 24, 2011 at 04:24 PM

BODS 3.2: Read in target table as source table before rows deleted


I have a target table whose rows are being deleted correctly per my design each run in a BODS 3.2 job. However, I'm trying to read in this target table also as a source table prior to the rows being deleted at the start of the job. In the target Options tab I've tried "Delete data from table before loading" and I've also tried Pre-Load Commands tab "DELETE FROM xxx" indepedently, but both of these delete the rows prior to the source table reading them in. Any suggestions?