To be effective, it would need to be applied in all countries at the same rate, lest foreign exchange transactions simply migrate to a country where the tax is not applied.
And if this substantial hurdle could be overcome, most observers believe that the effect of the tax would be to substantially diminish liquidity in financial markets, so that large ‘beneficial’ transactions would produce very large movements in the exchange rate.