tMysqlRow run before to delete rows fails

[contentengineer]

v2.0.0

 

We have a simple job to translate data from MS SQL to MySQL.

 

1. Delete existing rows (MySQL)

2. Input rows (MS SQL)

3. Output rows (MySQL)

 

Using following:

 

tMysqlRow_1 with run before

tMSSqlInput_1

tMysqlOutput_1

 

Latter two have tested OK on their own.

 

When run with tMysqlRow_1 and following query; the deletion does not appear to execute (i.e. rows do not disappear!)

 

DELETE from reportboss;

 

This command executes fine on MySQL Query browser using same userid.

 

Have tried adding: "START TRANSACTION; DELETE from reportboss ; COMMIT;" as part of query but this does not execute.

[contentengineer]

Problemo solved.... job not saved completely.