SSD is correctly marked Active but must have the System Boot files written to it to boot on its own. Did you run Startup Repair 3 separate times with reboots in between, with the other HD unplugged and SSD set to boot first?
If so boot free
Partition Wizard bootable CD, confirm Windows 7 active flag, then click on HD to highlight it, from Disk tab select Rebuild MBR, Apply. Reboot to see.
Next I would try installing EasyBCD 2.0 to the other HD to Add Windows 7 on SSD with all HD's connected.
If this fails it is likely because Recovery partition is not accepting the editing of the System boot files it holds. I hope you made your Recovery Disks because it may be otherwise corrupted. If you'd like to move your System boot files to C to try adding SSD, follow the procedure given earlier with SSD unplugged. You can later move Active flag back to Recovery if you need to run it, use the Disks as back up.
It might be easier to clean reinstall to SSD with HD unplugged, if repair efforts fail.