Simple example -1) Create a simple SSIS package that sends email or whatever you like (save it as indicated on ASP.NET code)2) On your web solution "Add reference..." > ".NET" tab > Microsoft.SQLServer.ManagedDTS3) Create Default.aspx (or whatever) with a Button (Button1) and add this stuffusing System;using System.Web;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using Microsoft.SqlServer.Dts.Runtime;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { Application app = new Application(); Package package = app.LoadPackage("C:\\Package.dtsx", null); DTSExecResult result = package.Execute(); }}
4) Email should arrive within seconds (make sure SSIS works beforehand for sure)This could be complicated as you want but might have issues with permissions, etc but at least this is a start.Good luck!