Triggering an SSIS package upon the receipt of an email message.
Much like a "Rule" in Microsoft Outlook, I'd like to set up a process where an (already created) SSIS package is executed upon the receipt of a particular email to a particular email address. What does everyone think the best approach would be for getting this kind of triggering working? I've preliminarily searched the net, but can't seem to get my searches to pull up specifically relevant information (everything I pull up is related to the send-mail SSIS task).Cheers,Delphoid
February 8th, 2010 7:12pm
Just a question. Can you trigger a batch file on receiving the specific mail?If yes you could call the package from the batch file and execute the package.Hope this helps !!
Sudeep|
My Blog
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2010 7:26pm
Just playing around with the rules in outlook 2003 for "Step 1: Select Actions" you can "start application" when you receive an email based on a rule. Think a bat file or program as the "application" and you should get what you're looking for. However, I'd still question whether or not this is the best route for handling this event to start the SSIS package. Is there not any other interface you can use to kick this off? I would think that outlook would have to be running on the server hosting SSIS (which would be kind of weird) or that you would have to invoke some other method of calling a stored procedure or job to start the package remotely (there are lots of threads on this). Hope this helps.Please mark answered posts. Thanks for your time.
February 8th, 2010 7:34pm
Thank you both very kindly for the reply!Essentially ... I have an automated process that posts a file to an FTP site, the remote vendor processes the data, and then once the processing is complete, I receive an email message indicating that the file is ready for pickup. Depending on how long the processing takes, it may be up to several hours before the email is received indicating that the file is ready.It is upon receipt of this email message that I would like to initiate the SSIS package which downloads the file and processes it.I agree that an Outlook Rule to launch a batch file calling the package may be a quick and dirty way to get this to work (great suggestion), but leaving Outlook open on a server is probably not the best long-term solution.Thank you again for the responses! I will continue to work on this and update the thread if I come up with any good solutions.Best,Delphoid
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2010 7:48pm
You might ask the vendor to FTP a file down to a server you can monitor as a "completion message". You could then use this event to kick off the job (via WMI or other methods, plenty of threads on this subject).Please mark answered posts. Thanks for your time.
February 8th, 2010 7:50pm
I have a similar situation. Have you found a solution to your issue?
Thanks,
Anusha
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 2:45pm