[wix-users] Rollback during Installation Error

[Ven H]

I am building an MSI for db installation. The DB team has provided me a
script to rollback or drop script which should be called in case of an
error. So, when an error occurs during installation, they want this script
to execute. So, I put this in an SqlScript with RollbackOnInstall=yes. But
it is not getting called during error. Can anyone please help?