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, |
|
|
|
|