Maybe this is because your page "Auto" doesn't exist. Why do you mean by no luck? You can trace but you do not see the DataTransform? Check if the page exist. How about if you call an Activity calling the DataTransformm can you see it then?
I think the page is not a problem because i am running Data Transform with page "Auto" on click of button and it is executing(please see the attachment). Where as in the attach content on the click event neither the DT nor the activity is working. Yes, I tried to trace and didn't see the DT in the tracer.
Any on-click actions set on the Actions tab are executed after a selected file is uploaded. Other events, such as "refresh action", can also be configured for the on-click action for this control, and are executed after the inherited behavior.