This might be possible with this SSIS component from CozyRoc.

http://www.cozyroc.com/ssis/receive-mail-task

This should allow you to detect when a target email is received,

and then you have the full power of...