I just tried some things today with our Xserve 2009 (3,1) with RAID card, but I think, that most if this stuff can be done with Xserves from 2006 (1,1) and 2008 (2,1) also:
A modern SATA SSD did not work in any real Xserve SATA-HDD drive module I have here. I have tested this with many different SATA drive modules and finally gave up.
In SATA drive modules the drive is connected to the little controller board at the back of the module using two black cables with black plugs - the smaller one for data, the wider one for power. AFAIK those SATA drive modules only support 1.5 Gbps and this is in many cases the reason, why modern 6 Gbps SSDs might not work.
But I still had this in mind:
You cannot use SAS drives in a SATA drive modules, but you can use SATA drives in SAS drive modules.
SAS is backwards compatible to SATA.
What I found out, is, that Apple shipped several drive modules which show on the bottom of the drive module, that they are SATA modules, but in fact, when you open them and remove the SATA drive, it turns out, that they are SAS drive modules. You can verify that reading the product code printed onto the little barcode label at the bottom of the drive bay inside the module. In SAS drive modules the drive is connected to one combined plug with data and power connector and only one wide transluscent copper flex cable. AFAIK those drive modules all support 3 Gbps and so many modern SATA HDDs and also SSDs should work.
I have successfully tested a Kingston Hyper X Fury 120 GB SSD (max. 6 GBps) in a 620-4575 SAS HDD Carrier and even in an older SAS drive Carrier from an Xserve 1,1 (620-4086) which originally was equipped with a 73 GB SAS drive.
In regard to the connection of the SSD to a SAS bay, you should consider to just connect the drive directly to the data/power plug without using any type of enclosure. If you intend to use a 2,5 -> 3,5" adapter enclosure which has its own activity LED, it might happen, that the blue activity LED of the drive module becomes inactive. Also I don't think, that it is neccessary to mount the SSD into the drive module like it was neccessary for hard drives which were rotating at high speeds like 7,200 rpm. One or two srews from the bottom which keep the SSD in position should do the job.
Trim Enabler actually does not recognize, if the drive supports TRIM. I think, that the reason is, that on all Intel Xserves the drives are connected to a SAS controller and not to a SATA controller. I don't think, that this is really a problem, because all modern SSDs have their own system of garbage collection.
My Xserve 3,1 booted from the Kingston SSD into OS X 10.10 without any problem from both SAS drive modules I mentioned above.
Blackmagic Disk Speed Test tested the SSD in a SAS drive module with 140 MBps (write) and 230 MBps (read).
IMO that was already quite OK for that SSD type connected to a 3 Gbps controller.
Perhaps this helps some of you guys to speed up your Xserves.