Jobs execution based in events

[juanvg1972]

I have a question about jobs execution in sqlserver B.I. 2005 platform.

I know that I can schedule a job that exec a sys in the platform, for example a batch execution, but I’m trying to launch a sys based in a event.

The event is an e-mail. When I receive a e-mail in outlook, I would like to take the attached file move it to a directory and exec a sys (SSIS pack) that use this file like input data in a ETL process.

Is that possible using sqlserver B.I. 2005 platform?, do I have to make a previous step?, I also can use MOSS 2007. I suppose that MOSS 2007 can have an agent to receive the e-mail, extract the attached file and call the sys of SQL Server.

I will prefer to make the whole process in sqlserver B.I. 2005 platform.

Any idea or suggestion will be greatly appreciated.


Thanks in advance,