Defined benefit transfer activity has fallen to its lowest level in more than six years, according to the XPS Pensions Group.