SQL Server Performance

Web Service Task

Discussion in 'SQL Server 2005 Integration Services' started by sandeepgulecha, Jan 8, 2007.

  1. sandeepgulecha New Member

    Hi All,

    In Sql Server 2005 Integration Service, I have created Web Service task which make calls WebMethod with parameter. I want to pass value for paramter to WebMethod in run-time when i am executing package in ASP.NET application. Please help me how to do this task and give me solution.

    Note: It is possible for me to call a WebMethod without Parameter in Web Service Task and can able to execute package in ASP.NET Application which is working fine.

  2. satya Moderator

  3. sandeepgulecha New Member

    First of all thanks for ur reply...I have gone thru this links..what i need is not covered..I want to pass value of parameter for the webmethod in run-time..<br /><br />Here is same code for Excuting Package in ASP.NET Appliction..This is code is working fine for webmethod without paramter...But i want to pass value in runtime..I am very new for SSIS..Do you any other alternativa way...<br /><br /><br />Code:<br />Application app = new Application();<br />Package objPack = app.LoadPackag@"D:SampleWorkSampleSSISSampleSSISinPackage.dtsx", null);<br />Variables vars = objPack.Variables;<br />//vars["User::Variable"].Value = "value from c#";<br />DTSExecResult result = objPack.Execute();<br />string strResult = vars["User:<img src='/community/emoticons/emotion-7.gif' alt=':s' />trResult"].Value.ToString();<br />

Share This Page