calling ssis package from asp.net

Posted by Srikanth007 under C# on 7/21/2010 | Views : 3788 | Status : [Member] | Replies : 2
Hi,
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#).




Responses

Posted by: BangaruBabu on: 7/22/2010 [Member] Starter

Up
0
Down
Hi,Could u Please Checkout these links For Reference

http://www.dotnetfunda.com/articles/article786-how-to-execute-ssis-packages-in-csharp-aspnet--part-i-.aspx

http://www.dotnetfunda.com/articles/article795-how-to-execute-ssis-packages-in-csharp-aspnet-part-ii-.aspx



BangaruBabu Pureti
http://bangarubabupureti.spaces.live.com/

Srikanth007, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 7/25/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Good day Srikanth007

as you can see in the image in the article , you need go to the Solution Explorer , if you cannot see it, Go to your view menu and you will see "Solution Explorer" and on your left hand side you will seeit. Right click on it and click "Add Reference" and you will taken to a dialogbox and select the reference from there

Thank you for posting at Dotnetfunda
[Administrator]

Srikanth007, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response