Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
juanvg1972
Starting Member
1 Post |
 Posted - 2011-09-24 : 09:57:45
|
| 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, |
|
|
|
|
|
Jobs execution based in events