I'm a beginner and am trying to execute a SSISpackage from a button click in asp.net. 've tried to follow the instructions in the article "How to execute SSIS package from C# ASP.NET" [link]www.dotnetfunda.com/articles/article795-how-to-execute-ssis-packages-in-csharp-aspnet-part-ii-.aspx[/link]
But got stuck with adding the reference Microsoft.SqlServer.Dts.Runtime to program.
Please tell me how to add this reference(where can I find this reference?) and any other better suggestions,to run the SSISpackage , are also welcome.
I'm working on Visual Studio 2010 (.Net 4.0)(c#).