I have a range of tables to transform from sql server to ms access. I have a
job which compacts and creates a *.mdb file and a transformation package.

The transformation was created in the design view. The transformation
sequence completes successfuly the task of transforming a sql database to an
ms access database apart from one table which results in an empty table.

I've opened the properties for that specific transformation and when I test
it I get a successful response. When I execute that transformation step, it
is successful.

The log file also does not indicate any failure.

In the Design View, I created an ActiveX task to open a MsgBox alert on
failure but nothing happens.